dataset
dataadapter
try { MAconn = new OleDbConnection(); MAconn.ConnectionString = connectionString; MAconn.Open(); DataSet oDS = new DataSet(); string query = "SELECT * FROM info"; OleDbDataAdapter oOrdersDataAdapter = new OleDbDataAdapter(query, connectionString); OleDbCommandBuilder oOrdersCmdBuilder = new OleDbCommandBuilder(oOrdersDataAdapter); oOrdersDataAdapter.Fill(oDS); DataTable pTable = oDS.Tables["Table"]; pTable.TableName = "info"; // edit data ( main code goes from here) DataRow oOrderRow = oDS.Tables["info"].Rows.Find("textbox1.Text"); oOrderRow["cell"]= "txtcell.Text"; oOrdersDataAdapter.Update(oDS, "info"); MessageBox.Show("deleted"); } catch (Exception ex) { MessageBox.Show("some prob" + ex); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)