private void button3_Click(object sender, System.EventArgs e)
{
dscus.AcceptChanges();
JXC.publicdata.UpdateDataset(dscus,"customer",conntodatabase.dataconn);
}
这是按钮事件代码如上:调用publicdata.UpdateDataset方法
{
dscus.AcceptChanges();
JXC.publicdata.UpdateDataset(dscus,"customer",conntodatabase.dataconn);
}
这是按钮事件代码如上:调用publicdata.UpdateDataset方法
{
using(SqlConnection qgf_SqlConnection=new SqlConnection())
{
qgf_SqlConnection.ConnectionString=this._strSQLString;
SqlCommand qgf_SqlCommand=new SqlCommand();
qgf_SqlCommand.Connection=qgf_SqlConnection;
qgf_SqlCommand.CommandType=CommandType.StoredProcedure;
qgf_SqlCommand.CommandText=selectCommand; qgf_Insert.Connection=qgf_SqlConnection;
qgf_Insert.CommandType=CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(qgf_SqlCommand);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter); adapter.InsertCommand=qgf_Insert; adapter.UpdateCommand=cmdBuilder.GetUpdateCommand();
adapter.DeleteCommand=cmdBuilder.GetDeleteCommand();
int val=0;
try
{
val= adapter.Update(qgf_DataTable);
qgf_DataTable.AcceptChanges();
}
catch(System.Exception Ex)
{
val=2;
}
finally
{
adapter.Dispose();
cmdBuilder.Dispose();
qgf_SqlCommand.Dispose();
qgf_SqlConnection.Dispose(); }
return val;
}
}