110,499
社区成员
发帖
与我相关
我的任务
分享
private void button5_Click(object sender, EventArgs e)
{
updateAccess();
}
private void updateAccess()
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb";
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from test1", conn);
conn.Open();
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "table");
DataTable table = dataSet.Tables["table"];
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = table;
DataView view = new DataView(table);
view.AllowNew = true;
view.AllowEdit = true;
view.AllowDelete = true;
DataRowView row = view.AddNew();
row.BeginEdit();
row[0] = Guid.NewGuid().ToString();
row.EndEdit();
adapter.Update(table);
row.BeginEdit();
row[1] = "TEST";
row.EndEdit();
adapter.Update(table); //DBConcurrencyException:Update...
conn.Close();
}
private void updateSQL()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pubs;server=(local)";
SqlDataAdapter adapter = new SqlDataAdapter("select * from test1", conn);
conn.Open();
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "table");
DataTable table = dataSet.Tables["table"];
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = table;
DataView view = new DataView(table);
view.AllowNew = true;
view.AllowEdit = true;
view.AllowDelete = true;
DataRowView row = view.AddNew();
row.BeginEdit();
row[0] = Guid.NewGuid().ToString();
row.EndEdit();
adapter.Update(table);
row.BeginEdit();
row[1] = "TEST";
row.EndEdit();
adapter.Update(table); //DBConcurrencyException:Update...
conn.Close();
}
private void button5_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pubs;server=(local)";
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select * from test1", conn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "table");
DataTable table = dataSet.Tables["table"];
DataView view = new DataView(table);
view.AllowNew = true;
view.AllowEdit = true;
view.AllowDelete = true;
DataRowView row = view.AddNew();
row.BeginEdit();
row[0] = Guid.NewGuid().ToString();
row.EndEdit();
adapter.Update(table);
row.BeginEdit();
row[1] = "TEST";
row.EndEdit();
adapter.Update(table); //DBConcurrencyException:Update...
conn.Close();
}