这是与SQL SERVER中的事务是一致的亚?请看MSDN
解决方案 »
- 谁帮忙用VS2005的C#做一个计算机或者扫雷,我想看看过程,自己做的bug很多
- 关于一个SQL查询
- oracle 按编号分组后 怎样让相邻的三个值的的时间相减呀
- 做一个WF窗体的启动项,就是让这个程序启动的时候首先会有一个图片出来,然后开始程序,后台代码怎么弄啊,前面的视图上需要PictureBox之外还需要什么吗
- 简单却面对后绞尽脑汁的问题 不可访问 因为它受保护级别限制 能救救小菜鸟的我吗
- 如何将一个WORD文档中指定颜色的字符保存到另一个WORD文档中
- 请问文本框中的属性信息是怎么设置的呀~~~~~~~~第一次做C#的应用程序,拜托在线等待回复
- c#数据插入问题
- 串口通讯
- 菜鸟问题,关于正则表达式得!
- VS.NET中"类库"和"组件类"有什么区别?
- 在ADO.NET里面有没有所谓像java中的数据库连接池这个概念??请指出,谢谢
Public Sub RunSqlTransaction(myConnString As String)
Dim myConnection As New SqlConnection(myConnString)
myConnection.Open()
Dim myCommand As New SqlCommand()
Dim myTrans As SqlTransaction
' Start a local transaction
myTrans = myConnection.BeginTransaction()
' Must assign both transaction object and connection
' to Command object for a pending local transaction
myCommand.Connection = myConnection
myCommand.Transaction = myTrans
Try
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
myCommand.ExecuteNonQuery()
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
myCommand.ExecuteNonQuery()
myTrans.Commit()
Console.WriteLine("Both records are written to database.")
Catch e As Exception
myTrans.Rollback()
Console.WriteLine("Error: {1}", e.Message)
Console.WriteLine("Error reported by {1}.", e.Source)
Console.WriteLine("Neither record was written to database.")
Finally
myConnection.Close()
End Try
End Sub 'RunSqlTransaction
[C#]
public void RunSqlTransaction(string myConnString)
{
SqlConnection myConnection = new SqlConnection(myConnString);
myConnection.Open(); SqlCommand myCommand = new SqlCommand();
SqlTransaction myTrans; // Start a local transaction
myTrans = myConnection.BeginTransaction();
// Must assign both transaction object and connection
// to Command object for a pending local transaction
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans; try
{
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Console.WriteLine("Both records are written to database.");
}
catch(Exception e)
{
myTrans.Rollback();
Console.WriteLine("Error: {1}", e.Message);
Console.WriteLine("Error reported by {1}.", e.Source);
Console.WriteLine("Neither record was written to database.");
}
finally
{
myConnection.Close();
}}ms-help://MS.VSCC/MS.MSDNVS.2052/cpref/html/frlrfsystemdatasqlclientsqltransactionclasstopic.htm