运行以下代码,提示 myData.Update(ds, "note");出错,请问是为什么?
private SqlDataAdapter myData;
private DataSet ds;
private void button1_Click(object sender, EventArgs e)
{
string cnStr = "Server = localhost;Integrated Security=true;database=cangku";
SqlConnection cn = new SqlConnection(cnStr);
String sqlStr = "select * from note where b=1";
SqlDataAdapter myData = new SqlDataAdapter(sqlStr, cn);
SqlCommandBuilder cb = new SqlCommandBuilder(myData);
DataSet ds = new DataSet();
myData.Fill(ds, "note");
dataGrid1.SetDataBinding(ds, "note");
}
private void button2_Click(object sender, EventArgs e)
{
myData.Update(ds, "note");
MessageBox.Show("abc");
}
|