string sqlwr =" begin TRANSACTION
update Department set departmentn = ' ' where departmentid=1
update Department set PowerID = 'ET' where departmentid=1COMMIT TRANSACTION;像这样多行的 sql 语句 怎么定义??
c#或者有没有更好的办法批量更新 同一项里面的不同列数据 ??
update Department set departmentn = ' ' where departmentid=1
update Department set PowerID = 'ET' where departmentid=1COMMIT TRANSACTION;像这样多行的 sql 语句 怎么定义??
c#或者有没有更好的办法批量更新 同一项里面的不同列数据 ??
string queryString, string tableName)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(queryString, connection);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter); connection.Open(); DataSet dataSet = new DataSet();
adapter.Fill(dataSet, tableName); //code to modify data in DataSet here builder.GetUpdateCommand(); //Without the SqlCommandBuilder this line would fail
adapter.Update(dataSet, tableName); return dataSet;
}
}
//执行事务处理
public void DoTran()
{ //建立连接并打开
SqlConnection myConn=GetConn();
myConn.Open();
SqlCommand myComm=new SqlCommand();
//SqlTransaction myTran=new SqlTransaction();
//注意,SqlTransaction类无公开的构造函数
SqlTransaction myTran;
//创建一个事务
myTran=myConn.BeginTransaction();
try
{
//从此开始,基于该连接的数据操作都被认为是事务的一部分
//下面绑定连接和事务对象
myComm.Connection=myConn;
myComm.Transaction=myTran; //定位到pubs数据库
myComm.CommandText="USE pubs";
myComm.ExecuteNonQuery();//操作1
myComm.CommandText=""; //操作2
myComm.ExecuteNonQuery();
//提交事务
myTran.Commit();
}
catch(Exception err)
{
myTran.rollback();
throw new ApplicationException("事务操作出错,系统信息:"+err.Message);
}
finally
{
myConn.Close();
}
}