SqlTransaction tranInsert;
private void TransactionInsert()
{
string ConnectString = ConfigurationSettings.AppSettings["XXX"];
SqlConnection Con = new SqlConnection(ConnectString);
private void TransactionInsert()
{
string ConnectString = ConfigurationSettings.AppSettings["XXX"];
SqlConnection Con = new SqlConnection(ConnectString);
try
{
Con.Open();
SqlTransaction tranInsert = Con.BeginTransaction();
Cmd = Con.CreateCommand();
Cmd.Transaction = tranInsert;
{
Con.Open();
SqlTransaction tranInsert = Con.BeginTransaction();
Cmd = Con.CreateCommand();
Cmd.Transaction = tranInsert;
。。。。。。
Cmd.ExecuteNonQuery();
tranInsert.Commit();
}
catch(Exception e)
{
tranInsert.Rollback();
}
finally
{
Con.Close();
}
tranInsert.Commit();
}
catch(Exception e)
{
tranInsert.Rollback();
}
finally
{
Con.Close();
}