PrivateSub Page_Load()Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load '在此处放置初始化页的用户代码 Dim SqlHelper AsNew SqlHelper ExecuteSqlTransaction(SqlHelper.sConnectString) End Sub PrivateSub ExecuteSqlTransaction()Sub ExecuteSqlTransaction(ByVal connectionString AsString) Dim connection AsNew Data.SqlClient.SqlConnection(connectionString) connection.Open() DimcommandAs Data.SqlClient.SqlCommand = connection.CreateCommand() Dim transaction As Data.SqlClient.SqlTransaction ' Start a local transaction transaction = connection.BeginTransaction("SampleTransaction") ' Must assign both transaction object and connection ' to Command object for a pending local transaction. command.Connection = connection command.Transaction = transaction Try '事务处理,第一次向数据库插入一条数据,接着第二次向数据库中插入相同一条数据,由于数据库关键字段有限制不能重复,第一次动用无效。 '事务处理是由以一个单一的逻辑单位完成的一系列操作,它可以由一系列的SQL语句、SELECT、INSERT、UPDATE、DELETE组成,如果在该单位包 &