database not updating

[Nir Amber via DotNetMonster.com]

I cant seem to get the databse to update the tables.
i get the following error
"System.InvalidOperationException: Missing the DataColumn 'description' in
the DataTable 'Transactions' for the SourceColumn 'description'."

here is the code im using. please will someone explain what i am doing wrong

regards

Nir

Dim strConn as string ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
server.mappath("/itinium2/Database/db.mdb") & ";"
dim conn as new OLEDBConnection(strconn)
dim cmd as new OLEDBCommand
dim mydataset as new dataset()
dim mydataAdapter as new oledbdataadapter()
dim dbrelation as dataRelation
sub page_load(source as object, e as eventargs)
dim strsql as string
dim drow as datarow
dim cbd as new oledbcommandbuilder(mydataadapter)
dim dtable as new datatable
cmd.connection = conn
cmd.commandtype = commandtype.text
conn.open()

'fill dataAdapter with 1st Table (transactions)
strsql = "select * from transactions"
cmd.commandtext = strsql
mydataAdapter.selectcommand = cmd
'mydataAdapter.fillschema(mydataset, schematype.mapped)
mydataAdapter.fill(mydataset, "Transactions")

'fill dataAdapter with 2nd Table (link_transactions2details)
strsql = "select * from link_transactions2details"
cmd.commandtext = strsql
mydataAdapter.selectcommand = cmd
'mydataAdapter.fillschema(mydataset, schematype.mapped)
mydataAdapter.fill(mydataset, "LinkTable")

'fill dataAdapter with 3rd Table (transaction_details)
strsql = "select * from transaction_details"
cmd.commandtext = strsql
mydataAdapter.selectcommand = cmd
'mydataAdapter.fillschema(mydataset, schematype.mapped)
mydataAdapter.fill(mydataset, "Details")
conn.close()

'******** create table relationships *************************

'link linktable to transactions
dbrelation = new dataRelation("TransLink",mydataset.tables("linkTab le")
..columns("t_id"),mydataset.tables("Transactions") .columns("id"))
mydataset.relations.add(dbrelation)

'link linktable to details
dbrelation = new dataRelation("detailLink",mydataset.tables("linkTa ble")
..columns("d_id"),mydataset.tables("Details").colu mns("id"))
mydataset.relations.add(dbrelation)

'******** end create table relationships ********************

'Insert data into tranasaction table
dtable = mydataset.tables("Transactions")
drow = dtable.NewRow()
drow("t_type_id") = 1
dtable.Rows.Add(drow)
mydataadapter.insertcommand = cbd.getinsertcommand()
mydataadapter.update(mydataset,"Transactions")
myDataSet.Tables("Transactions").AcceptChanges()
end sub

--
Message posted via http://www.dotnetmonster.com