如何在vb.net中使用Transact-SQL 事务，sqltransaction类的使用,要求命名空间:System.Data.SqlClient中国IT动力H7GYYEl平台:Windows98,WindowsNT4.0,WindowsME,Windows2000,WindowsXPHomeEdition,WindowsXPProfessional,WindowsServer2003系列,.NETFramework精简版-WindowsCE.N,
您现在的位置：编程资料,学习资料,c,c++,vc,vc++,java,jsp,j2ee,j2me,asp,php >> 文章中心 >> .NET 专区 >> NET 技术 >> 文章正文

【字体：小大】

如何在vb.net中使用Transact-SQL 事务，sqltransaction类的使用进入问吧

本站地址:http://www.bajiao123.com

作者：admin 文章来源：不详点击数：更新时间：2007-6-1

如何在vb.net中使用Transact-SQL 事务，sqltransaction类的使用

要求

命名空间: System.Data.SqlClient中国IT动力H7GYYEl

平台: Windows 98, Windows NT 4.0, Windows ME, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 系列, .NET Framework 精简版 - Windows CE .NET中国IT动力H7GYYEl

程序集: System.Data (在 System.Data.dll 中)中国IT动力H7GYYEl

表示要在 SQL Server 数据库中处理的 Transact-SQL 事务。不能继承此类。中国IT动力H7GYYEl

有关此类型所有成员的列表，请参阅 SqlTransaction 成员。中国IT动力H7GYYEl

System.Object
System.MarshalByRefObject
System.Data.SqlClient.SqlTransaction中国IT动力H7GYYEl

[Visual Basic]NotInheritable Public Class SqlTransaction   Inherits MarshalByRefObject   Implements IDbTransaction, IDisposable

中国IT动力H7GYYEl

[C#]public sealed class SqlTransaction : MarshalByRefObject,   IDbTransaction, IDisposable

中国IT动力H7GYYEl

[C++]public __gc __sealed class SqlTransaction : public   MarshalByRefObject, IDbTransaction, IDisposable

中国IT动力H7GYYEl

[JScript]public class SqlTransaction extends MarshalByRefObject implements   IDbTransaction, IDisposable

中国IT动力H7GYYEl

线程安全

此类型的所有公共静态（Visual Basic 中为 Shared）成员对多线程操作而言都是安全的。但不保证任何实例成员是线程安全的。中国IT动力H7GYYEl

备注

应用程序通过在 SqlConnection 对象上调用 BeginTransaction 来创建 SqlTransaction 对象。对 SqlTransaction 对象执行与该事务关联的所有后面的操作（例如提交或中止该事务）。中国IT动力H7GYYEl

示例

[Visual Basic, C#] 下面的示例创建一个 SqlConnection 和一个 SqlTransaction。它还演示如何使用 BeginTransaction、Commit 和 Rollback 方法。中国IT动力H7GYYEl

[Visual Basic] Public Sub RunSqlTransaction(myConnString As String)    Dim myConnection As New SqlConnection(myConnString)    myConnection.Open()        Dim myCommand As SqlCommand = myConnection.CreateCommand()    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      Try        myTrans.Rollback()      Catch ex As SqlException        If Not myTrans.Connection Is Nothing Then          Console.WriteLine("An exception of type " & ex.GetType().ToString() & _                            " was encountered while attempting to roll back the transaction.")        End If      End Try          Console.WriteLine("An exception of type " & e.GetType().ToString() & _                      "was encountered while inserting the data.")      Console.WriteLine("Neither record was written to database.")    Finally      myConnection.Close()    End TryEnd Sub 'RunSqlTransaction

中国IT动力H7GYYEl

[C#] public void RunSqlTransaction(string myConnString)  {    SqlConnection myConnection = new SqlConnection(myConnString);    myConnection.Open();    SqlCommand myCommand = myConnection.CreateCommand();    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)    {      try      {        myTrans.Rollback();      }      catch (SqlException ex)      {        if (myTrans.Connection != null)        {          Console.WriteLine("An exception of type " + ex.GetType() +                            " was encountered while attempting to roll back the transaction.");        }      }          Console.WriteLine("An exception of type " + e.GetType() +                        " was encountered while inserting the data.");      Console.WriteLine("Neither record was written to database.");    }    finally     {      myConnection.Close();    }}

中国IT动力H7GYYEl

[C++, JScript] 没有可用于 C++ 或 JScript 的示例。若要查看 Visual Basic 或 C# 示例，请单击页左上角的“语言筛选器”按钮。中国IT动力H7GYYEl

要求

命名空间: System.Data.SqlClient中国IT动力H7GYYEl

程序集: System.Data (在 System.Data.dll 中)中国IT动力H7GYYEl

进入问吧

本站地址:http://www.bajiao123.com

文章录入：admin 责任编辑：admin

上一篇文章：关 SQLDMO 组件在一些用法!

下一篇文章： Visual Basci中的几个函数split(),ubound(),lbound(),instr(),mid().

【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】

没有相关文章