473,326 Members | 2,095 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Update and delete sql not generated by wizard

Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select sql
statements but not delete and update. As a result the data is not updated
when changed in form. What is the problem and how can I get the update and
delete statements generated?

Thanks

Regards
Mar 4 '07 #1
7 1651
I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.
--------------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select
sql statements but not delete and update. As a result the data is not
updated when changed in form. What is the problem and how can I get the
update and delete statements generated?

Thanks

Regards


Mar 4 '07 #2
Plenty of data in there. I can insert data just not update. Any ideas?

Thanks

Regards

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:K_******************************@comcast.com. ..
>I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.
--------------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
>Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select
sql statements but not delete and update. As a result the data is not
updated when changed in form. What is the problem and how can I get the
update and delete statements generated?

Thanks

Regards



Mar 4 '07 #3
John,

I thought that it was when you was using timestamps, because in the other
situations I have tried it and it went well, however that was a while ago
that I did something with these generated statements.

Cor

"John" <Jo**@nospam.infovis.co.ukschreef in bericht
news:e9**************@TK2MSFTNGP04.phx.gbl...
Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select
sql statements but not delete and update. As a result the data is not
updated when changed in form. What is the problem and how can I get the
update and delete statements generated?

Thanks

Regards


Mar 4 '07 #4
You need to have a primary key defined.

"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select
sql statements but not delete and update. As a result the data is not
updated when changed in form. What is the problem and how can I get the
update and delete statements generated?

Thanks

Regards


Mar 4 '07 #5
It's funny how the same questions get asked and answered repeatedly on the
forums. While some may say that this is the user's fault, I would say that
it is a failure by Microsoft to make the "obvious" truly obvious and to do a
better job of explaining the "obvious". Too often, the information being put
out is too disjointed.

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:K_******************************@comcast.com. ..
>I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.
--------------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
>Hi

In my vb winform data app with sql server 2005 backend, when in dataset I
run the data adapter configuration wizard it generates insert and select
sql statements but not delete and update. As a result the data is not
updated when changed in form. What is the problem and how can I get the
update and delete statements generated?

Thanks

Regards



Mar 4 '07 #6
And some people, not getting a response, or not getting the response they
want, post their questions more than once.

Robin S.
----------------------------------------
"Earl" <br******@newsgroups.nospamwrote in message
news:ub****************@TK2MSFTNGP06.phx.gbl...
It's funny how the same questions get asked and answered repeatedly on
the forums. While some may say that this is the user's fault, I would say
that it is a failure by Microsoft to make the "obvious" truly obvious and
to do a better job of explaining the "obvious". Too often, the
information being put out is too disjointed.

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:K_******************************@comcast.com. ..
>>I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.
--------------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
>>Hi

In my vb winform data app with sql server 2005 backend, when in dataset
I run the data adapter configuration wizard it generates insert and
select sql statements but not delete and update. As a result the data
is not updated when changed in form. What is the problem and how can I
get the update and delete statements generated?

Thanks

Regards




Mar 4 '07 #7
Does your table have a primary key?

Robin S.
-----------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Plenty of data in there. I can insert data just not update. Any ideas?

Thanks

Regards

"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:K_******************************@comcast.com. ..
>>I could swear I've answered this before. Isn't your data table empty? Did
you try adding data to your tables and regenerating the dataset to see if
that was the problem?

Robin S.
--------------------------------
"John" <Jo**@nospam.infovis.co.ukwrote in message
news:e9**************@TK2MSFTNGP04.phx.gbl...
>>Hi

In my vb winform data app with sql server 2005 backend, when in dataset
I run the data adapter configuration wizard it generates insert and
select sql statements but not delete and update. As a result the data
is not updated when changed in form. What is the problem and how can I
get the update and delete statements generated?

Thanks

Regards




Mar 4 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jason Shohet | last post by:
What we've done so far in our web applications: 1. We have no datasets dragged-and-dropped in Visual Studio. They are all defined in the code, generated at runtime. 2. when a user updates or...
9
by: Pam Ammond | last post by:
I need the code to update the database when Save is clicked and a text field has changed. This should be very easy since I used Microsoft's wizards for the OleDBAdapter and OleDBConnection, and...
2
by: Joe Fetters via .NET 247 | last post by:
Have googled and read the VS.NET documentation can't seem to getthe answer to the following. Environment: Framework 1.1 VB.NET WinForm Access database Using all automagic tools (DataAdapter...
3
by: Simon | last post by:
Hi everyone, I have a small problem regarding a wizard that I'm making on my website. The wizard is obviously a series of pages that take values from the user. My question is: - Should I...
1
by: David | last post by:
Hi, I am trying to a field in a Access database, and I have used the code generated by the Web Matrix UPDATE code wizard. When the update function is called, no errors are generated, but no...
1
by: JJ | last post by:
Hi All, is there a limit to the size of an update or delete command that a data adapter will automatically create. I have just added another varchar field to my table and when I attempt to now...
1
by: N! Xau | last post by:
Hi all, I created a dataform using the wizard, everything works fine. I set both grids to readonly = true, and added a button to switch this property and save modifications to db. I didn't make...
3
by: =?Utf-8?B?THVib21pcg==?= | last post by:
Hi, I have a DataGridView that displays data from one table from database. I didn’t implement any my code, I just used wizard to do all the work with DatagridView populating. Visual Studio...
5
by: =?Utf-8?B?UlBhcmtlcg==?= | last post by:
I used the wizard to generate a typed dataset for my table and let it create my SPROCs. It created everything, and the GetData() method and the custom GetByUserName query works great, but when I...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.