Update database records

[static_blue]

Okay i have set an oledbConnection, my adapters and datasets. Added a datagrid to my form and in the forms load event set up the connection and filled the datagrid.

OleDbConnection1.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=dataBase.mdb"

DataAdapter1.Fill(DataSet11)

Now how would i update the dataBase if i add new information in the datagrid?

Thanks

[aniskhan]

One way is to generate the dataAdapter's commands using oleDbCommandBuilder object that builds InsertCommand ,DeleteCommand,Update Command for the dataAdapter and then use the Update Command of dataBase to make changes into dataSource.
Link

You can also specify the SelectCommand, InsertCommand ,DeleteCommand,Update Command in code and then use them to update the dataSource after editting in dataTable bound to dataGrid.Post