新学习C#,求把下面VB.NET代码改成C#

[zhxiongying]

求把下面VB.NET代码改成C#

                Using SqlConn1 As New SqlClient.SqlConnection(FormMain.SqlConnERP)
                    SqlConn1.Open()
                    Dim SqlComm1 As SqlClient.SqlCommand = SqlConn1.CreateCommand()
                    Dim Transaction As SqlClient.SqlTransaction

                    Transaction = SqlConn1.BeginTransaction("SampleTransaction") '以指定的事务名称启动数据库事务。
                    SqlComm1.Connection = SqlConn1
                    SqlComm1.Transaction = Transaction
                    Try
                        SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
                        SqlComm1.ExecuteNonQuery()

                        SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
                        SqlComm1.ExecuteNonQuery()

                        Transaction.Commit() '提交数据库事务
                    Catch ex As Exception
                        Transaction.Rollback() '从挂起状态回滚事务。 
                    End Try
                    SqlConn1.Close()
                End Using

[蝶恋花雨]

using (System.Data.SqlClient.SqlConnection SqlConn1 = new System.Data.SqlClient.SqlConnection(FormMain.SqlConnERP)) { SqlConn1.Open(); System.Data.SqlClient.SqlCommand SqlComm1 = SqlConn1.CreateCommand(); System.Data.SqlClient.SqlTransaction Transaction = null; Transaction = SqlConn1.BeginTransaction("SampleTransaction"); //以指定的事务名称启动数据库事务。 SqlComm1.Connection = SqlConn1; SqlComm1.Transaction = Transaction; try { SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"; SqlComm1.ExecuteNonQuery(); SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"; SqlComm1.ExecuteNonQuery(); Transaction.Commit(); //提交数据库事务 } catch (Exception ex) { Transaction.Rollback(); //从挂起状态回滚事务。 } SqlConn1.Close(); } http://www.developerfusion.com/tools/convert/vb-to-csharp/ 给你转换的地址

[sosoben]

using (System.Data.SqlClient.SqlConnection SqlConn1 = new System.Data.SqlClient.SqlConnection(FormMain.SqlConnERP)) {
		SqlConn1.Open();
		System.Data.SqlClient.SqlCommand SqlComm1 = SqlConn1.CreateCommand();
		System.Data.SqlClient.SqlTransaction Transaction = null;

		Transaction = SqlConn1.BeginTransaction("SampleTransaction");
		//以指定的事务名称启动数据库事务。
		SqlComm1.Connection = SqlConn1;
		SqlComm1.Transaction = Transaction;
		try {
			SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
			SqlComm1.ExecuteNonQuery();

			SqlComm1.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
			SqlComm1.ExecuteNonQuery();

			Transaction.Commit();
			//提交数据库事务
		} catch (Exception ex) {
			Transaction.Rollback();
			//从挂起状态回滚事务。 
		}
		SqlConn1.Close();
	}
}

用这个转的，希望你会喜欢 http://www.developerfusion.com/tools/convert/vb-to-csharp/?batchId=c2fdae36-9987-4e84-bfd7-40f19f242c74