sql = "select * from line";
myCommand = new OleDbCommand(sql,conn);
myAd.SelectCommand = myCommand;
OleDbCommandBuilder lineCb = new OleDbCommandBuilder(myAd);
//将读取结果填充如数据集中
myAd.Fill(dataSet1,"line");
dataGrid1.SetDataBinding(dataSet1,"line");改在sql = "select * from line";
myCommand = new OleDbCommand(sql,conn);
myAd.SelectCommand = myCommand;
OleDbCommandBuilder lineCb = new OleDbCommandBuilder(myAd);
//将读取结果填充如数据集中
DataSet ds = new DataSet();
myAd.Fill(ds,"line");
dataGrid1.SetDataBinding(ds,"line");试试
myCommand = new OleDbCommand(sql,conn);
myAd.SelectCommand = myCommand;
OleDbCommandBuilder lineCb = new OleDbCommandBuilder(myAd);
//将读取结果填充如数据集中
myAd.Fill(dataSet1,"line");
dataGrid1.SetDataBinding(dataSet1,"line");改在sql = "select * from line";
myCommand = new OleDbCommand(sql,conn);
myAd.SelectCommand = myCommand;
OleDbCommandBuilder lineCb = new OleDbCommandBuilder(myAd);
//将读取结果填充如数据集中
DataSet ds = new DataSet();
myAd.Fill(ds,"line");
dataGrid1.SetDataBinding(ds,"line");试试
Clear只能清除数据,原有的表结构是不会清除的
myAd.Fill(ds,"line");
staAd.Upadte(dataSet1,"line")报 insert into 语句错误!
我的执行后myAd.InsertCommand好像是为空