110,539
社区成员
发帖
与我相关
我的任务
分享
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=stu.mdb";
OleDbConnection conn;
OleDbDataAdapter myAdapter;
DataSet myDataSet = new DataSet();
private void Form1_Load(object sender, EventArgs e)
{
string selectCmd = "Select * from student";
conn = new OleDbConnection(connStr);
conn.Open();
myAdapter = new OleDbDataAdapter(selectCmd, conn);
myAdapter.Fill(myDataSet, "student");
dataGridView1.DataSource = myDataSet;
dataGridView1.DataMember = "student";
}
private void dataGridView1_CellValidated(object sender, DataGridViewCellEventArgs e)
{
OleDbCommandBuilder ocb = new OleDbCommandBuilder(myAdapter);
myAdapter.Update(myDataSet, "student");
}