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 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
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
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
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
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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...
| |