MyDMnew2.UpdateData方法如下(其他部分省略):
public void UpdateData(DataSet DataSet, string TableName)
{
SqlDataAdapter DataAdapter = new SqlDataAdapter();
DataAdapter.Update(DataSet,"TableName");
DataAdapter.Dispose();
}
中的“TableName”是没有双引号的!
public void UpdateData(DataSet DataSet, string TableName)
{
SqlDataAdapter DataAdapter = new SqlDataAdapter();
DataAdapter.Update(DataSet,"TableName");
DataAdapter.Dispose();
}
中的“TableName”是没有双引号的!
例如:SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter);myConn.Open();DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS, "Customers");
这样在只写查询语句的情况下,可以进行其它操作。
注意:查询的表必须有主键。
How many tables in this dataset?
public void UpdateData(DataSet DataSet, string TableName)
{
SqlDataAdapter DataAdapter = new SqlDataAdapter();
DataAdapter.Update(DataSet,TableName);
DataAdapter.Dispose();
}
读取数据时用到的跟你要调用Update方法的适配器应该是同一个。在此你不能用new出来,我觉得你可以试试看:public void UpdateData(DataSet DataSet, string TableName)
{
this.BindingContext[this.DataSet,TableName].EndCurrentEdit();
try{
this.myDataAdapter.Update(DataSet,TableName);
DataAdapter.Dispose();
}
catch(Exception err)
{
Debug.Fail(err.Message);//别忘了添加引用:using System.Diagnostics;
}
}
}
DataAdapter.Dispose();
中的myDataAdapter是取什么地方的呢?