Excel导入数据库

 private void btnSelect_Click(object sender, EventArgs e)
  {
   OpenFileDialog open = new OpenFileDialog();
   open.Filter = "Text Documents (*.xls)|.xls|AllFiles|*.*";
   open.ShowDialog();
   this.textBox1.Text = open.FileName;

  }

  private void btnExcelToSql_Click(object sender, EventArgs e)
  {
   int count = 0;
   string strPath = this.textBox1.Text;
   if (strPath == "")
   {
    MessageBox.Show("请选择文件", "提示", MessageBoxButtons.OK);
    return;
   }
   string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0';Data Source=" + strPath;
   try
   {
    OleDbConnection oleDbconnection = new OleDbConnection(sConnectionString);
    oleDbconnection.Open();

    DataTable dataTable = oleDbconnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
    string query = "SELECT  *  FROM [Sheet1$]  ";
    DataSet dataset = new DataSet();

    OleDbDataAdapter oleAdapter = new OleDbDataAdapter(query, sConnectionString);

    oleAdapter.Fill(dataset);
    if (dataset == null)
    {
     MessageBox.Show("null", "WARNING", MessageBoxButtons.OK);
    }
    oleDbconnection.Close();

    //daoru shujuku
    DataTable sqlTable = new DataTable();
    SqlDataAdapter sqlDap = new SqlDataAdapter("SELECT * FROM StudentInfo", Comm.DatabseConnectString);
    SqlCommandBuilder sqlCmb = new SqlCommandBuilder(sqlDap);
    sqlDap.Fill(sqlTable);
    Data.ReadStudentInfo rStudentInfo = new XAZH.Gov.Personnel.DX.Data.ReadStudentInfo (Comm.DatabseConnectString ,Comm.DatabaseConnect);
    DataSet ds = new DataSet ();
    Data.WriteStudentInfo wStudentInfo = new XAZH.Gov.Personnel.DX.Data.WriteStudentInfo(Comm.DatabseConnectString ,Comm.DatabaseConnect);

    for (int i = 1; i < dataset.Tables[0].Rows.Count; i++)
    {
     DataRow dr = sqlTable.NewRow();
     dr[0] =dataset .Tables [0].Rows [i][0];
     dr[1] =dataset .Tables [0].Rows [i][1];
     dr[2] =dataset .Tables [0].Rows [i][2];
     dr[3] =dataset .Tables [0].Rows [i][3];
     dr[4] =dataset .Tables [0].Rows [i][4];
     dr[5] =dataset .Tables [0].Rows [i][5];
     dr[6] =dataset .Tables [0].Rows [i][6];
     dr[7] =dataset .Tables [0].Rows [i][7];
     dr[8] =dataset .Tables [0].Rows [i][8];
     dr[9] =dataset .Tables [0].Rows [i][9];
     dr[10]=dataset .Tables [0].Rows [i][10];
     dr[11]=dataset .Tables [0].Rows [i][11];
     dr[12]=dataset .Tables [0].Rows [i][12];
     dr[13]=dataset .Tables [0].Rows [i][13];
     dr[14]=dataset .Tables [0].Rows [i][14];
     dr[15]=dataset .Tables [0].Rows [i][15];
     dr[16]=dataset .Tables [0].Rows [i][16];
     dr[17]=dataset .Tables [0].Rows [i][17];
     dr[18]=dataset .Tables [0].Rows [i][18];
     dr[19]=dataset .Tables [0].Rows [i][19];
     ds =rStudentInfo .GetRecord (dr[0].ToString(), dr[1].ToString(), Int32 .Parse ( dr[2].ToString()));
     if(ds.Tables [0].Rows .Count  !=0)
     {
      wStudentInfo.DeleteStudentInfo(dr[0].ToString(), dr[1].ToString(), Int32.Parse(dr[2].ToString()));
      count++;
     }
     sqlTable.Rows.Add(dr);
    }
    sqlDap.Update(sqlTable);
    MessageBox.Show("共有"+ count +"条记录被覆盖","导入成功 ",MessageBoxButtons.OK);

   }
   catch (Exception)
   {

    MessageBox.Show("lianjiecuowu", "WARNING", MessageBoxButtons.OK);
   }
  }