常用的EXCEL数据导入SQL SERVER的方法

最新推荐文章于 2025-07-23 12:00:57 发布

转载最新推荐文章于 2025-07-23 12:00:57 发布 · 71 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Hdsome/archive/2008/06/11/1217417.html

本文提供了一个使用C#从Excel文件中读取数据并将其导入到SQL Server数据库的示例代码。通过OleDbDataAdapter从Excel中获取数据，并利用SqlCommand执行SQL插入语句完成数据导入。

protected void Button1_Click(object sender, EventArgs e)
{
string sqlconn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;

          string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/examples.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
          OleDbConnection   cnnxls   =   new   OleDbConnection   (mystring);
          OleDbDataAdapter   myDa   =new   OleDbDataAdapter("select *from [Sheet1$]",cnnxls);
          DataSet   myDs   =new   DataSet();
          myDa.Fill(myDs);
          cnnxls.Close();
          if(myDs.Tables[0].Rows.Count   >   0)
          {
              string   strSql   =   "";

             SqlConnection conn = new SqlConnection(sqlconn);
              conn.Open   ();
              SqlCommand   myCmd   =null;

          for(int   i=0;   i<myDs.Tables[0].Rows.Count; i++)
          {
              strSql = "insert   into   hitch(hName,num) values   ('";
              strSql   +=   myDs.Tables[0].Rows[i].ItemArray[0].ToString()   +   "',   '";
              strSql   +=   myDs.Tables[0].Rows[i].ItemArray[1].ToString()   +   "')";

              try
              {
              myCmd=new SqlCommand(strSql,conn);
              myCmd.ExecuteNonQuery();
              }
              catch
              {
               Response.Write("<script language='javascript'>alert('数据导入失败.');</script>");
              }
          }
              Response.Write( "<script language='javascript'>alert('数据导入成功.');</script>");
              conn.Close();
         }

     }

转载于:https://www.cnblogs.com/Hdsome/archive/2008/06/11/1217417.html