Insert new row via dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dataset that filled by me via datatables, and data rows, and not by dataadaptor
How can I associate this table with DB table, in order to insert a new row into the DB
 
Provided the schemas match , it's all in the update logic of whatever
dataadapter you want.. just map the columns you want to head back to the db
to the columns in your datatable. when the values change, the rowstate will
change and then the dataadapter will see them, just add a valid
update/insert/delete statement and you're off to the races.

Cheers,

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting Multi Table Dataset into Dataset 1
Clear a datatable before inserting new records 7
Insert Performance 4
Creating the DataTable objects within a Dataset from the DB itself 4
VBA - retrieve data on last create named range from previous inserted named range 0
DataSet.Fill Times out in Transaction 4
OleDbCommandBuilder insert query will not work? dataset to Access 4
DataGrid / DataSet / DataAdaptor / DataBase update issue 13

Back
Top