PDA

View Full Version : Insertcommand problem


Geo
05-03-2003, 10:24 AM
I'm up against a wall trying to learn data use in ASP.Net. I can retrieve data OK but can't INSERT (or most likely UPDATE either). I'm using the data connections and adapters in VS.NET, and in spite of a mountain of books, can't get a handle on it.

Can someone put me on the right path?

When attempting to do an insert, I get this message:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.</font id="red">

refering to: dbaProblems.InsertCommand.CommandText = strSQL

dcVeh is an oledbdataconnector
dbaProblems is an oledbdataadapter
dsVP is a dataset

my code:
Dim strSQL As String
Dim myRow As Data.DataRow

dbcVeh.Open()
dbaProblems.Fill(DsVP)

strSQL = "INSERT INTO tblProblems ( PRB_VID, PRB_Driver, RB_Driver_Rem )"

myRow = DsVP.Tables("tblProblems").NewRow
myRow("PRB_VID") = lblID.Text
myRow("PRB_Driver") = lblDriver.Text
myRow("PRB_Driver_Rem") = txtRemarks.Text
DsVP.Tables("tblProblems").Rows.Add(myRow)

dbaProblems.InsertCommand.CommandText = strSQL
dbaProblems.Update(DsVP, "tblproblems")</font id="red">
dbcVeh.Close()
[xx(]

Geo B