基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

   string[] filelist = Directory.GetFiles(Server.MapPath("~/website1/xxtables"));
   if (Request["dir"] != null) filelist = Directory.GetFiles(Server.MapPath("~/website1/" Request["dir"].ToString()));
     foreach (string fileInfo in filelist)
     {
         List<string>errorList=new List<string>();

         //string fileName = "users.sql";
         //if (Request["sqlfile"] != null) fileName = Request["sqlfile"].ToString();
         //string strSql = System.IO.File.ReadAllText(Server.MapPath("~/website1/"   fileName   ""));
         ////Response.Write(strSql);
         /// 
         string strSql = System.IO.File.ReadAllText(fileInfo);


         string constr = "data source=.;uid=sa;pwd=1@1.com;database=21744new"; // 定义链接字符窜


         SqlConnection conn = new SqlConnection(constr);
         conn.Open();

         SqlCommand cmd = new SqlCommand();
         cmd.Connection = conn;
         //cmd.CommandText = strSql;            //为SqlCommand赋Sql语句;
         //cmd.ExecuteNonQuery();
         //conn.Close();



         //ArrayList Lists = Lj.ExecuteSqlFile(Server.MapPath("NetShop.sql")); //调用ExecuteSqlFile()方法，反回 ArrayList对象;
         String[] Lists = strSql.Split(new string[] {"\r\nGO\r\n"}, StringSplitOptions.RemoveEmptyEntries);
         string teststr = ""; //定义遍历ArrayList 的变量;
         string errorMsg = "";
         foreach (string varcommandText in Lists)
         {
             try
             {
                 teststr = varcommandText; //遍历并符值;
                 //Response.Write(teststr   "|@|<br>");
                 cmd.CommandText = teststr; //为SqlCommand赋Sql语句;
                 cmd.ExecuteNonQuery();
             }
             catch (Exception ex)
             {
                 errorList.Add(ex.Message);
                 errorMsg  = teststr   "<br/>";
             }
             //执行
         }
         conn.Close();

         Response.Write("执行完毕 ok啦,错误信息如下：errorMsg："   errorList.Count.ToString() ">>" fileInfo "<br/>");
     }