Chat rightnow without registration - Dataadapter not updating datatable

"Rich" wrote: Dim da As New Sql Data Adapter("Select * from tbl1", conn) dim tblx As New Data Table da. Now I can see the update in the client app as well as the sql server.

dataadapter not updating datatable-6

Update(tblx) '--tblx/tbl1 not getting updated here. But if I do this---then it works OK (not using data Adapter though) Dim cmd As New Sql Command cmd.

Command Text = "Update tbl1 set fld1 = 'test' where ID = 1" da.

var microsoft = microsoft || ; microsoft.support = microsoft.support || ; microsoft.support.content = (function(){ return { "click Tale Configuration": , "Internal Content Config": , "Mwf Configuration": , "Rps Sign In Info": , "Site Content Config": { "Link Farm Enabled": true, "One Site Service Uri": "https://uhf.microsoft.com//shell/xml/?

Dim da As New Sql Data Adapter("Select * from tbl1", conn) dim tblx As New Data Table da.

All the insert, update and delete handling for a table are made dynamicly while using the dataadapter after doing this command. Command Text = "Update tbl1 set fld1 = @p1 where ID [email protected]" da. I have never seen in this newsgroups or by myself a real wrong behaviour of the commandbuilder.

Thanks, Rich Rich, Your update command is incomplete, with a dataadapter you normally test if there is no problem with the optimistic concurrency. Have a look at this most simple sample on our website. ...2-d7c12bbb3726 If you have a simple update as this mostly the commandbuilder makes your life much easier. Like the designer it can only use one not joined table with a primary key and hold a maximum of 100 fields. Then I updated the items in the datarow that I wanted to change. Now I can see the update in tblx(datatable) tbl1 (sql server table). What I did was to assign a datarow object to the row I wanted to update and Parameters to the Update Command and modified the commandtext to use parameters. The Update Command on my Data Adapter seems to work now. But when I was trying to use the Adapter - I was not updating tblx which is what updates tbl1 on the sql server. "Cor Ligthert [MVP]" wrote: Rich, I have seen those messages about the commandbuilder as well. Add(New Sql Parameter("@Original_Auto Id", Sql Db Type. Input, False, nb, nb, _ "Auto Id", Data Row Version. Original, Nothing)) ' What you see is that there is a Update and a Select in it. The Update Command on my Data Adapter seems to work now. Add(New Sql Parameter("@p1, Sql DBtype.varchar, 10, "fld1") Dim dr As Data Row = tblx. Update(tblx) '--now I can see the update in tblx/tbl1 the example using cmd was only updating tbl1 on the sql server. Update(tblx) '--tblx/tbl1 not getting updated here. But if I do this---then it works OK (not using data Adapter though) Dim cmd As New Sql Command cmd. It does the same with the delete and the insert by the way. Command Text = "UPDATE Sample SET What Ever = @What Ever WHERE (Auto Id = @Original_Auto Id) " & _ "AND (What Ever = @Original_What Ever OR @Original_What Ever IS NULL AND What Ever IS NULL); " & _ "SELECT Auto Id, What Ever FROM Sample WHERE (Auto Id = @Auto Id)" cmd Update. May I ask what the Select statement in the Update Command performs? Add(New Sql Parameter("@Original_What Ever", _ Sql Db Type. Input, False, nb, nb, _ "What Ever", Data Row Version. All the insert, update and delete handling for a table are made dynamicly while using the dataadapter after doing this command. Command Text = "Update tbl1 set fld1 = @p1 where ID [email protected]" da. I have never seen in this newsgroups or by myself a real wrong behaviour of the commandbuilder. All the insert, update and delete handling for a table are made dynamicly while using the dataadapter after doing this command.

Tags: , ,