C#中的事务

Question

如果你使用ado.net访问sql server，可以参考：http://www.google.com.hk/search?hl=zh-CN&q=msdn+sqltransaction&hl=zh-CN&sourceid=cndr当然最重要地是你以前上学时学过数据库系统基本概念，如果有印象那么就重新学习一遍。没有基础而临时抱佛脚，不一定总是可以滥竽充数。

Answer 1

public static int ExecuteSqlTran(List<String> SQLStringList)
        {
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                SqlTransaction tx = conn.BeginTransaction();
                cmd.Transaction = tx;
                try
                {
                    int count = 0;
                    foreach (String sqlStr in SQLStringList)
                    {
                        if (sqlStr.Trim().Length > 1)
                        {
                            cmd.CommandText = sqlStr;
                            count += cmd.ExecuteNonQuery();
                        }
                    }
                    tx.Commit();
                    return count;
                }
                catch
                {
                    tx.Rollback();
                    return 0;
                }
        }