public class sqlservershiwu
    {
        public string sqlconString = "Data Source=.;Initial Catalog=TestDB;User ID=sa;Password=123456789";
        public void findAll()
        {
            bool flag = false;
            int result = 0;
            using (SqlConnection con = new SqlConnection(sqlconString))
            {
                con.Open();
                SqlCommand com = new SqlCommand();
                com.CommandType = System.Data.CommandType.Text;
                com.Connection = con;
                //共享锁
                SqlTransaction st = con.BeginTransaction(IsolationLevel.ReadCommitted);
                //开始执行事务
                com.Transaction = st;
                try
                {
                    string sql1 = "delete from testTable where id = 1";
                    com.CommandText = sql1;
                    result += com.ExecuteNonQuery();
                    string sql2 = "delete from testTable where id = 2";
                    com.CommandText = sql2;
                    result += com.ExecuteNonQuery();
                    string sql3 = "delete from testTable where id = q";
                    com.CommandText = sql3;
                    result += com.ExecuteNonQuery();
                    string sql4 = "insert into testTable(id,name)values(‘3‘,‘3‘)";
                    com.CommandText = sql4;
                    result += com.ExecuteNonQuery();
                    //提交事务
                    st.Commit();
                    flag = true;

                }
                catch (Exception ex)
                {
                    flag = false;
                    //事务回滚
                    st.Rollback();
                    throw ex;
                }
            }
        }
    }