dataGridView1.CurrentRow.Cells[1].Value = textBox2.Text;
DataSet dataSet = new DataSet();
OleDbDataAdapter dataAdapter;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb");
conn.Open();
string SelectAll = "select * from " + dt;//dt为当前表名
dataAdapter = new OleDbDataAdapter(SelectAll, conn);
dataAdapter.Fill(dataSet, dt);
dataGridView1.DataSource=dataSet.Tables[dt];
OleDbCommandBuilder builder = new OleDbCommandBuilder(dataAdapter);
dataAdapter.Update(dataSet, dt);//需要添加主键
conn.Close();我想将textbox的内容给datagridview,然后用dataAdapter.Update保存修改。请问,数据库为什么不能修改啊?哪里出了问题。
初学c#,万分着急啊~~~~~~~~~~~~~~~~~~~c# datagridviewdataAdapter
DataSet dataSet = new DataSet();
OleDbDataAdapter dataAdapter;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb");
conn.Open();
string SelectAll = "select * from " + dt;//dt为当前表名
dataAdapter = new OleDbDataAdapter(SelectAll, conn);
dataAdapter.Fill(dataSet, dt);
dataGridView1.DataSource=dataSet.Tables[dt];
OleDbCommandBuilder builder = new OleDbCommandBuilder(dataAdapter);
dataAdapter.Update(dataSet, dt);//需要添加主键
conn.Close();我想将textbox的内容给datagridview,然后用dataAdapter.Update保存修改。请问,数据库为什么不能修改啊?哪里出了问题。
初学c#,万分着急啊~~~~~~~~~~~~~~~~~~~c# datagridviewdataAdapter
还是那句话,自己写增、删、改、查。
如果你真想这么做,我建议你用sql工具,性能工具自己去监听下。