Insert command and update database

[CookieNZ]

The following sub is used to store in the dataset a new record/row.

With dssupport.Tables("Supportcall&quot
NewRow = .NewRow()
NewRow("ID&quot = Me.txtcallnumber.Text
NewRow("Description&quot=Me.txtcalldescription.Text
.Rows.Add(NewRow)
End With

However when I come to hit the update the database with

Dim NewRow As System.Data.DataRow

I am bombed out with a insertcommand error.

How and where do I configure this?



dbsupport.Update(dssupport, "Supportcall&quot

 

[djs1138]

The Insert Command will be associated with the Data Adapter.
You can create it by selecting the adapter on the form in the Design view and choosing Configure Adapter. I've been using SQL Adapters I'm pretty sure it'll work with the OLE DB adapter as well.

Another way is to create the SQL statement you want in code as a string. Then create a SQL Command and assign the SQL text you created to it. Then use the Execute method of the command.

Or, assign the SQL text you created to the Insert Commmand Text property of the adapter your using. Hope this helps.

 

[CookieNZ]

What would the syntax be if I was to create the SQL command and where would I call it?