c#中事務、批量提交、回滾的寫法

public void UpdateContactTableByDataSet(DataSet dsstring strTblName)
{
try
{
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlConnection  conn = new SqlConnection(strConnection);
SqlCommand myCommand = new SqlCommand(select * from strTblNameconn);
myAdapterSelectCommand = myCommand;
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);

connOpen();
SqlTransaction myTrans = connBeginTransaction();
myCommandTransaction = myTrans;

try
{
myAdapterUpdate(dsstrTblName);
myTransCommit();
}
catch(Exception e)
{
try
{
myTransRollback();
}
catch (SqlException ex)
{
if (myTransConnection != null)
{
ConsoleWriteLine(回滾失敗! 異常類型: + exGetType());
}
}
}
finally
{
connClose();
}

}
catch(Exception ex)
{
throw ex;
}
}

From:http://tw.wingwit.com/Article/program/net/201311/15608.html