事务提交SQL Server [英] Transaction commit sql server

问题描述

嗨.

我对提交aspgridview的数据感兴趣.

Hi.

I have interested in commiting aspgridview''s data.

推荐答案

您好，交易通常是这样的:

bool SaveValues(字符串名称，字符串父亲名称，字符串电子邮件地址，字符串地址)
{
bool result = false;
SqlConnection sqlconn =新的SqlConnection();
SqlCommand command1 =新的SqlCommand(插入tabel1(name，parentname)values(""+ name +"''，" + Fathername +'')");
SqlCommand command2 =新的SqlCommand(插入tabel2(电子邮件，地址)值(""+电子邮件+"''，" +地址+'')";

SqlTransaction trx = sqlconn.BeginTransaction();
command1.Transaction = trx;
command2.Transaction = trx;

试试
{
command1.ExecuteNonQuery();
command2.ExecuteNonQuery();
trx.Commit();
result = true;
}
捕获(SqlException ex)
{
result = true;
trx.Rollback();
}
终于
{
//清理资源
}
返回结果；
}

祝你好运.

Hi transactions usually works like this:

bool SaveValues(string name, string fathername, string email, string address)
{
bool result=false;
SqlConnection sqlconn = new SqlConnection();
SqlCommand command1 = new SqlCommand("insert into tabel1(name, fathername) values(''" + name + "'',''" + fathername + "'')");
SqlCommand command2 = new SqlCommand("insert into tabel2(email, address) values(''" + email + "'',''" + address + "'')";

SqlTransaction trx = sqlconn.BeginTransaction();
command1.Transaction = trx;
command2.Transaction = trx;

try
{
command1.ExecuteNonQuery();
command2.ExecuteNonQuery();
trx.Commit();
result=true;
}
catch (SqlException ex)
{
result=true;
trx.Rollback();
}
finally
{
//clean up resources
}
return result;
}

Best of luck.

这篇关于事务提交SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！