#region Excel格式文件上传到数据库
    protected void Button4_Click(object sender, EventArgs e)
    {
        string fileName = FileUpload1.FileName;
        string fPath = Server.MapPath("UploadFiles//") + fileName;//文件保存的路径，服务器上的绝对路径
        string type = fileName.Substring(fileName.LastIndexOf(".") + 1);//获取文件后缀名
        //Label1.Text = type;
        if (type != "xls")
            Response.Write("<script language=\"javascript\">alert('只接受上传Excel文件！')</script>");
        else
        {
            //上传文件
            FileUpload1.SaveAs(fPath);string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + fPath + "';Extended Properties=Excel 8.0";
            OleDbConnection cnnxls = new OleDbConnection(mystring);
            OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls);
            DataSet myDs = new DataSet();
            myDa.Fill(myDs, "表");
            GridView1.DataSource = myDs.Tables["表"];
            Bind();//从excel文件获得数据后，插入记录到SQL Server的数据表
            SqlConnection sqlCon = new SqlConnection("Data Source=服务器;Initial Catalog=数据库;User ID=用户名;Password=密码");

            DataTable dataTable1