C # using TransactionScope transactions to import data routines

Using System.Transactions;

Try
{

using (TransactionScope scope = new TransactionScope ())
{


var count = DC. ExecuteCommand (@ "INSERT into Bg_count_month (TJ_MONTH,EMP_ID,EMP_NAME,COUNT_MONTH,COUNT_DAY,MONEY,DW)
Select Tj_month,emp_id,emp_name,count_month,count_day,money,dw from Bg_count_month_import ");
Lable_message. Text = "Number of imported records:" + count;
dc. ExecuteCommand ("Delete from Bg_count_month_import");
Scope.complete ();

}
Gridview2.datasourceid = "SqlDataSource1";
Gridview2.databind ();
Response.Write (Myui.javascript_alert (lable_message. Text));

}

catch (Exception E1)
{
Lable_message. Text = E1. Message;
Response.Write (Myui.javascript_alert ("Error: Import data Error! "));
}

C # using TransactionScope transactions to import data routines