Error white updating records

[vcharles]

Hello,

I am getting the following error message at daaop5.Update(ds).

Update unable to find TableMapping['Table'] or DataTable 'Table'.

Any ideas what's causing the error?

Thanks

Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\aop29.mdb"
Dim objConnection As New OleDb.OleDbConnection(ConnectionString)
Dim sql As String = "Select * from Customer"
Dim daaop5 As New OleDb.OleDbDataAdapter(sql, objConnection)
Dim cmdb As New OleDbCommandBuilder(daaop5)

Dim ds As New DataSet()
daaop5.Fill(ds, "Customer")
daaop5.Update(ds, "Customer")
C1TrueDBGrid1.AllowAddNew = True
daaop5.SelectCommand.CommandText = ("INSERT INTO Customer(Description) VALUES('" & C1TrueDBGrid1.Columns(0).Value & "')")
ds.Clear()
daaop5.Update(ds) ----Error Line
daaop5.Fill(ds)

 

[ZmrAbdulla]

Not sure this will help but

daaop5.[COLOR=red]InsertCommand.CommandText[/color] = ("INSERT INTO Customer(Description) VALUES('" & C1TrueDBGrid1.Columns(0).Value & "')")

Zameer Abdulla

 

[vcharles]

Sorry, it didn't work, It gives me the folowing error message.

Object reference not set to an instance of an object.

Victor

 

[Sorwen]

First, you don't need to update a DataAdapter unless you make changes. Now for the actual error you can't update a DataAdapter with an empty DataSet because there is nothing to update.

Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\aop29.mdb"
Dim objConnection As New OleDb.OleDbConnection(ConnectionString)
Dim sql As String = "Select * from Customer"
Dim daaop5 As New OleDb.OleDbDataAdapter(sql, objConnection)
Dim cmdb As New OleDbCommandBuilder(daaop5)

Dim ds As New DataSet()
daaop5.Fill(ds, "Customer")
daaop5.Update(ds, "Customer")
C1TrueDBGrid1.AllowAddNew = True
daaop5.SelectCommand.CommandText = ("INSERT INTO Customer(Description) VALUES('" & C1TrueDBGrid1.Columns(0).Value & "')")
ds.Clear() [red]<---Bad if before update[/red]
daaop5.Update(ds) ----Error Line
daaop5.Fill(ds)

What exactly are you wanting to do?

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!

 

[vcharles]

Hello,

Thanks for pointing out the bad code. I would like to enter multiple data in a grid and save all all the rows entered to a dadabase.


Victor