Insert Command and Update database

[CookieNZ]

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

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

However when I come to hit the update the database with

dbsupport.Update(dssupport, "Supportcall")

I am bombed out with a insertcommand error.

How and where do I configure this?

[wolfofthenorth]

You might be able to configure it in the DataAdapter Configuration Wizard.

You could also declare command objects in code, and have them update the database.

Did you use the IDE controls and drag them on the form, or did you declare all the objects in code?

[CookieNZ]

I declared them in code

Dim dbsupport As New OleDbDataAdapter()
Dim dssupport As New DataSet()
Dim saved As Boolean
Dim dbconn As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;" & "Data Source =P:\Support Calls\mosaic.mdb")
Dim cmdsupport As New OleDbCommand()

with

cmdsupport = dbconn.CreateCommand
cmdsupport.CommandText = "select * from Supportcall"
dbsupport.SelectCommand = cmdsupport

dbsupport.Fill(dssupport, "SupportCall")

declared in the form load

[Frans C]

It looks like you didn't create an insert command at all. In order to insert a record, the dataadapter needs an insert command (and for updates and deletes an update and a delete command as well).

Have a look at this tutorial: Using ADO.NET