SQL Insert Update

[richself]

I'm looking for good code examples on updating and/or inserting new records into a SQL database. I've written an App for writing to an Acess Database but now am trying the same with SQL and am getting nowhere. I'm working with a Dataset, which I can insert new rows into fine and the changes will display in a datagrid on my form but the changes do not take effect in the SQL table. If I could get an example with just 1 column I could go from there.

Below is the code I use to update the datagrid.

Dim insertcmd As SqlCommand

insertcmd = New SqlCommand("INSERT INTO Test (ShiftID, SupervisorID) VALUES (@ShiftID, @SupervisorID), myConn")

insertcmd.Parameters.Add("@ShiftID", SqlDbType.Char, 10, "ShiftID")
insertcmd.Parameters.Add("@SupervisorID", SqlDbType.Char, 10, "supervisorID")

myDA.InsertCommand = insertcmd

 

[bboffin]

Take a look at the Update method of the DataAdapter. This will apply any changes that have been made to the in memory dataset.

It's best to use the DataAdapter's configuration wizard to generate the INSERT, UPDATE and DELETE commands if possible.


Bob Boffin

 

[richself]

The problem with using the Wizard is I'm using VB.Net 2003 Standard Edition which does not allow you to use a SQL connection through the wizard. I had to make my connection string manually and am having to everything else manually.

 

[edderic]

insertcmd.ExecuteNonQuery()



Eric De Decker
Visit The Belgium "Visual Basic Group" at

http://www.vbgroup.org

 

[chrissie1]

It's best to use the DataAdapter's configuration wizard to generate the INSERT, UPDATE and DELETE commands if possible.

you must be joking, right?

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]