SqlTransaction - JackHu88/Comm GitHub Wiki

using (SqlConnection SqlCon = new SqlConnection(connectionstring))
{
    SqlCon.Open();
    SqlTransaction myTran = SqlCon.BeginTransaction();
    SqlCommand SqlCmd = new SqlCommand() { Connection = SqlCon, CommandTimeout = 10 };
    SqlCmd.Transaction = myTran;
    try
    {
        string sqlText = string.Empty;

        foreach (UpdateRecord oitem in UpdateRecords)
        {
            string sqlWhere = " Where Division= 'XXX' ";
            sqlText = " Update Employee Set Status=1, ModifiedDate = '" + DateTime.Now + "' ";
            sqlText += sqlWhere;
            SqlCmd.CommandText = sqlText;
            SqlCmd.ExecuteNonQuery();
        }
        myTran.Commit();
    }
    catch (Exception ex)
    {
        myTran.Rollback();
    }
    finally
    {
        SqlCon.Close();
    }
}