Dataset updating database

Hope this helps Jay Cor, Sorry wrong URL, I changed pages in the browser, but the url did not change, try this page (the page immediately after the one I sent before). Fill(nwind DS, "Categories") dim dr Row as datarow = nwind DS.tables("Categories").

Accept Changes on each row that it processes, so you don't need to call Accept Changes after calling Data Adapter. Command Text = "INSERT INTO Categories (Category Name, Description) VALUES (@Category Name, @Description)" Sql Insert Command1. I basically copy and pasted generated code for this fragment. Tom ==== Sub Main() Dim nwind Conn As Sql Connection = New Sql Connection ("Data Source=COL-TP5170-LT1\VSdot NET; Integrated Security=SSPI; Initial Catalog=Northwind;") Dim nwind DA As Sql Data Adapter = New Sql Data Adapter ("SELECT Category ID, Category Name, Description FROM Categories", nwind Conn) nwind Conn. I basically copy and pasted generated code for this fragment. Tom ==== Sub Main() Dim nwind Conn As Sql Connection = New Sql Connection ("Data Source=COL-TP5170-LT1\VSdot NET; Integrated Security=SSPI; Initial Catalog=Northwind;") Dim nwind DA As Sql Data Adapter = New Sql Data Adapter ("SELECT Category ID, Category Name, Description FROM Categories", nwind Conn) nwind Conn.

Hi, I am trying to insert a row into the Categories Table in Nothwinds database in MSDE. Now it appears that it is at least trying to process an Insert. Now it appears that it is at least trying to process an Insert.

Hope this helps Jay "tomp" wrote in message news:00****************************@.. Here is another page not write what you say, but what I think you mix up. I concluded that removing it seemed the most logical). (But I never use that, I bring it into if it is complex, I hate SQL) I added also the test for if the datase has changes (here always of course), than it skips the update if that is not, little bit nicer. I concluded that removing it seemed the most logical).

Here is another page not write what you say, but what I think you mix up. Cor Cor, See: section close to the middle that starts "When using Update, the order of execution is as follows". NVar Char, 1073741823, "Description")) ' Dim nwind DS As Data Set = New Data Set() nwind DA. That you can do using the designer that makes it and then copy and paste it. I was changing little things, but after all I have changed all your code, not because it was fault, but that was easier to show, look to it as an alternative. NVar Char, 1073741823, "Description")) ' Dim nwind DS As Data Set = New Data Set() nwind DA.

Fill(nwind DS, "Categories") Dim dt Table As Data Table Dim dr Row As Data Row dt Table = nwind DS. New Row() dr Row("Category Name") = "New Category Name" dr Row("Description") = "New Description" dt Table. (I even have searched for "using" on that page) Did you send maybe the wrong link? Close() End Sub Hi Tom, Read it to the end before you become afraid If you do it nice you have to make an Insert, an Update, and a Delete command. Close() End Sub Cor, Thanks so much for taking the time to show me how to make this work. I copied/pasted your code into my ide, made a few minor syntax fixes and got the following error : Unhandled Exception: System.

Leave a Reply