public DataSet GetDataSet(string filePath){  string Connstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filePath + "';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");  OleDbConnection Conn = new OleDbConnection(Connstr);  //創建ArrayList對象 存放所有sheetname   ArrayList sheetNamelist = new ArrayList();  //獲取配置Excel中sheet總數(這里是根據項目需求配置的) 如果需要導入Excel表格所有sheet數據則將此代碼刪除  int sheetCount = Convert.ToInt32(ConfigurationManager.AppSettings["sheetCount"].ToString());  DataSet dsExcel = new DataSet();  try  {   if (Conn.State == ConnectionState.Closed)   {    Conn.Open();   }   DataTable dtExcelSchema = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });   string sheetName = string.Empty;   if (dtExcelSchema.Rows.Count > sheetCount)   {    Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--alert('很抱歉!你上傳Excel文件sheet總數過多不能大于10個sheet..!! ')// --></mce:script>");    return;   }   else   {    for (int j = 0; j < dtExcelSchema.Rows.Count; j++)    {     sheetName = String.Format("Sheet{0}$", j + 1);     sheetNamelist.Add(sheetName);    }   }  }  catch (Exception ex)  {   throw new Exception(ex.Message.ToString(), ex);  }  finally  {   Conn.Close();  }  try  {   string strSQL = string.Empty;   for (int i = 0; i < sheetNamelist.Count; i++)   {    strSQL = "select * from [" + sheetNamelist[i].ToString() + "]";    OleDbDataAdapter da = new OleDbDataAdapter(strSQL, Conn);    DataTable dtExcel = new DataTable(sheetNamelist[i].ToString());    da.Fill(dtExcel);    dsExcel.Tables.Add(dtExcel);   }   return dsExcel;  }  catch (Exception ex)  {   throw new Exception(ex.Message.ToString(), ex);  } } //從Excel 表中取出數據 將取出來的數據插入到數據庫中 public void InsertData(DataSet ds) {   string strSQL=string.Empty;   if (ds.Tables[0].Rows.Count > 0)   {    for (int j = 0; j < ds.Tables.Count; j++)     {     for(int i=0;i<ds.Tables[j].Rows.Count;i++)    {     DataRow dr=ds.Tables[j].Rows[i];     //組名     string groupname = dr["組名"].ToString().Trim();     //聯系人     string contactName = dr["聯系人"].ToString().Trim();     //手機號碼     string mobile = dr["手機號碼"].ToString().Trim();     //公司名稱     string companyName = dr["公司名稱"].ToString().Trim();     //公辦號碼     string officeNum = dr["辦公號碼"].ToString().Trim();     //家庭號碼     string homeNum = dr["家庭號碼"].ToString().Trim();     //郵箱     string Email = dr["郵 箱"].ToString().Trim();     //聯系地址     string address = dr["聯系地址"].ToString().Trim();     //創建時間     string createtime = dr["創建時間"].ToString().Trim();     //性別     string Sex = dr["性別"].ToString().Trim();     //手機套餐類型     string mobileType = dr["手機套餐類型"].ToString().Trim();     //是否開通通信助理     string isOpen = dr["是否開通通信助理"].ToString().Trim();     //SQL 語句     strSQL = "insert into msm_Excel(groupName,Mobile,Name,companyName,officeNum,homeNum,Emial,address,Createtime,Sex,mobileType,isOpen)values('" + groupname + "','" + mobile + "','" + contactName + "','" + companyName + "','" + officeNum + "','" + homeNum + "','" + Email + "','" + address + "','" + createtime + "','" + Sex + "','" + mobileType + "','" + isOpen + "')";     try     {      int n = SQLHelper.SqlDataExecute(strSQL);      if (n > 0)      {       Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--alert('數據插入成功!')// --></mce:script>");       Label1.Text = "一共成功插入" + ds.Tables[j].Rows.Count.ToString() + "條數據";      }      else      {       Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--alert('服務器繁忙！請稍候再試..!')// --></mce:script>");      }     }     catch (Exception ex)     {      throw ex;     }    }   }      }  else {   Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--alert('此Excel文件中無數據!!!')// --></mce:script>");  } }//調用//獲取上傳文件名  string fileName = FileUpload1.FileName;   //判斷是否存在上傳文件  if (FileUpload1.PostedFile.FileName.Length == 0) {   Page.RegisterStartupScript("", "<mce:script type="text/javascript"><!--alert('請選擇你要上傳的Excel文件!!')// --></mce:script>");  }   //判斷上傳的文件類型是否正確  else if (!Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower().Equals(".xls") && !Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower().Equals(".xlsx"))  {   Page.RegisterStartupScript("", "<script>alert('很抱歉!你上傳的文件類型不正確!只能上傳Excel類型的文件!')</script.");  }  else  {   //獲取上傳的文件路徑   filePath = Server.MapPath("TxtFiles//") + DateTime.Now.ToString("yyyyMMddhhmmss") + fileName;   this.FileUpload1.PostedFile.SaveAs(filePath);   ds = GetDataSet(filePath);   InsertData(ds);  }