Updating database from an editable datagrid

Thankx, it works now.

I take it dtGrdData is the DataGrid object. Go to Microsoft Visual Studio Help search type in "DataGrid Members". You will see that the Update method is to update the drawn window seen by the user that to teh user is the datagrid. To update a RDBMS table from a dataset DataTable, you call the DataAdapter.Update method. I take it your da is global.

Hi, I declared it before but it does not seem to update it in the database. The program compiles but it says that the ds and the da are never being used. I think the update is just updating any dataset ds. Can someone help me on how to update data from an editable datagrid to the database?? Also for some reason it is not taking anything for my UPDATE. I have that line commented out in the bottom of my code. Here is my full code: private DataSet ds; private OleDbDataAdapter da; private void btnSubmitChange_Click(object sender, System.EventArgs e) { try { OleDbConnection conn = new OleDbConnection(ConnectionString); conn.Open();//conn.CreateCommand(); if(lstBxSelectData.SelectedItem.ToString()=="Tbl_Questions") { string getData = "SELECT * FROM Tbl_Questions"; OleDbDataAdapter da = new OleDbDataAdapter(getData,conn); DataSet ds = new DataSet(); da.Fill(ds); dtGrdData.SetDataBinding(ds,"Tbl_Questions"); ds.Tables["Tbl_Questions"].DefaultView.AllowEdit= true; ds.Tables["Tbl_Questions"].DefaultView.AllowDelete = true; } else if(lstBxSelectData.SelectedItem.ToString()== "Tbl_DropDownList") { //pretty mych same code.....................} private void btnChange_Click(object sender, System.EventArgs e) { OleDbCommandBuilder bd = new OleDbCommandBuilder(da); //dtGrdData.Update(ds,"Tbl_Questions"); //saying the above line is not correct. So I am using the bottom // one. As a result its ot updating in the database. dtGrdData.Update(); }