asp.net事务处理范例

最新推荐文章于 2025-08-08 16:37:23 发布

doneter

最新推荐文章于 2025-08-08 16:37:23 发布

阅读量444

点赞数

CC 4.0 BY-SA版权

文章标签： asp.net insert exception class server

本文链接：https://blog.youkuaiyun.com/doneter/article/details/2217311

本文通过一个具体的C#示例，展示了如何使用SQL事务来确保数据库操作的一致性和完整性。包括连接数据库、开启事务、执行SQL命令及提交或回滚事务的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SqlConnection myConnection = new SqlConnection("Server=localhost;Database=***;uid=***;pwd=***;");
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
// 为事务创建一个命令
myCommand.Transaction = myTrans;
try
{
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (100, '100')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "Insert into class_title (title_name, num) VALUES (101, '100')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Response.Write("Both records are written to database.");
}
catch(Exception d)
{
myTrans.Rollback();
Response.Write(d.ToString());
Response.Write("Neither record was written to database.");
}
finally
{
myConnection.Close();
}