EXCEL导入数据库

 if (!(FileUpload1.HasFile))
            {
                Common.MessageBox.Show(this, "请选择文件!");
                return;
            }
            if (System.IO.Path.GetExtension(FileUpload1.FileName.ToString()) != ".xls")
            {
                Common.MessageBox.Show(this, "只能上传.xls的Excel文件!");
                return;
            }

             string filename = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
            string filesave = Server.MapPath("/upload/" + filename);
            FileUpload1.SaveAs(filesave);
            DataSet ds = LoadDataFromExcel(filesave);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("insert into xx());
                sb.Append("values(");
                sb.Append();
                Socut.Data.ExecuteNonQuery(sb.ToString());
            }

           // MessageBox.Show(this, "导入完成!");
public static DataSet LoadDataFromExcel(string filePath)
        {          
            try     
            {       
                string strConn;
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
                OleDbConnection OleConn = new OleDbConnection(strConn);
                OleConn.Open();   
                String sql = "SELECT * FROM  [Sheet1$]";//可更改Sheet名称，比如sheet2，等等 
                OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);  
                DataSet OleDsExcle = new DataSet();  
                OleDaExcel.Fill(OleDsExcle, "Sheet1");   
                OleConn.Close();        
                return OleDsExcle;           
            }          
            catch (Exception err) 
            {
                HttpContext.Current.Response.Write("数据绑定Excel失败!失败原因：" + err.Message);
                return null;      
            }    
        }