EXCAL导入数据库 C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.IO;
public partial class admindatain : System.Web.UI.Page
{
     protected void Page_Load(object sender, EventArgs e)
     {
     }
     protected void Button1_Click(object sender, EventArgs e)
     {
         bool yesno = false;
         if (FileUpload1.HasFile)
         {
             string fileContentType = FileUpload1.PostedFile.ContentType;
             if (fileContentType == "application/vnd.ms-excel")//验证文件类型
             {
                 string excalname = FileUpload1.FileName;//获取文件名
                 string Excalwebpath = Server.MapPath("App_Data/" + excalname);//文件服务器路径
                 if (!File.Exists(Excalwebpath))
                 {
                     FileUpload1.SaveAs(Excalwebpath);//上传文件
                     yesno = true;//上传成功
                 }
                 else
                 {
                     Label2.Text = "请重命名文件后再上传";//文件名重复
                 }
                 if (yesno == true)
                     datain(Excalwebpath);//读取Excal数据并保存到数据库
             }
             else
             {
                 Label2.Text = "文件类型不符，请选择Excal文件！";
             }
         }
       
      
    }
     private void datain(string path)
     {
         string strcn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";//连接字符串
         OleDbConnection excalcn = new OleDbConnection(strcn);
         try
         {
             string sql = "select 学号,姓名,性别,系别,班级 from [Sheet1$]";
             excalcn.Open();
             OleDbDataAdapter oldr = new OleDbDataAdapter(sql, excalcn);//读取数据，并填充到DATASET里
             DataSet ds = new DataSet();
             oldr.Fill(ds);
             excalcn.Close();
             if (ds.Tables[0].Rows.Count > 0)//DATASET数据写入数据库
             {
                 for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                 {
                     SqlConnection cn = sqldata.createcon();
                     string sql1 = "insert into student(学号,姓名,性别,系别,班级) values(N'" + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "',N'" + ds.Tables[0].Rows[i].ItemArray[1].ToString() + "',N'" + ds.Tables[0].Rows[i].ItemArray[2].ToString() + "',N'" + ds.Tables[0].Rows[i].ItemArray[3].ToString() + "',N'" + ds.Tables[0].Rows[i].ItemArray[4].ToString() + "')";
                     try
                     {
                         cn.Open();//打开连接
                         SqlCommand cmd1 = new SqlCommand(sql1, cn);
                         cmd1.ExecuteNonQuery();
                         Label2.Text="导入成功";
                     }
                     catch (Exception err)
                     {
                         Label2.Text = "导入失败:" + err.Message;
                     }
                     finally
                     {
                         cn.Close();//关闭连接
                     }
                 }
             }
         }
         catch (Exception err)
         {
             Label2.Text = "导入失败" + err.Message;
         }
     }
     }
}
自己写的代码，我自己随便加了注释~马马虎虎能看明白吧
Excal数据连接字符串里
hdr=yes      有两个值:yes/no,表示第一行是否字段名,默认是yes,第一行是字段名  
imex=1      解决数字与字符混合时,识别不正常的情况