How to use the GetInsertCommand method?

Question

i used the named method like this:

ds.Tables("Employees").Rows.Add(ENumTxt.Text, ENameTxt.Text,PosTxt.Text,EAgeTxt.Text,_
ESalTxt.Text, EPhonTxt.Text, EAdrsTxt.Text)
If ds.HasChanges Then
            Dim AffectedDS As DataSet = ds.GetChanges(DataRowState.Added)
            Dim ComBuilder As New OleDb.OleDbCommandBuilder(da)
            da.InsertCommand = ComBuilder.GetInsertCommand()
            da.Update(AffectedDS, "Employees")
End If

---

but when i check the insertcommand at run time, it looks like:

INSERT INTO Employees Values(?,?,?,?,?,?,?)

where are the values i entered in the text boxes?

Answer 1

They are probably in the Parameters collection of the InserCommand. Look at da.InsertCommand.Parameters.