学步园

string str = "server=" + CustomerUtil.SQLServerName + ";uid=" + CustomerUtil.SQLUser
                                            + ";pwd=" + CustomerUtil.SQLsapass + ";database=" + CustomerUtil.SQLDataBase;//数据库连接字符串
                                using (SqlConnection conn = new SqlConnection(str))
                                {
                                    conn.Open(); //打开数据库连接
                               

                                    using (SqlTransaction transaction = conn.BeginTransaction()) //使用事务
                                    {
                                        try
                                        {
                                            //TODO　增删改数据库操作。
                                          

                                            transaction.Commit();//事务提交
                                        }
                                        catch (Exception e)
                                        {
                                            transaction.Rollback();//回滚
                                            
                                            throw e;
                                        }
                                    }
                                }//事务结束