Excel表格导入数据库代码

 protected void btnInster_Click(object sender, EventArgs e)
    {
       

        if (FileUpload1.HasFile == false)
        {
            Response.Write("<script>alert('请选择Excel表格！！')</script>");
            return;
        }
        string filename = FileUpload1.FileName;
        string savePath = Server.MapPath(filename);

        FileUpload1.SaveAs(savePath);
        DataTable dt = CreateDataSource(savePath);

     
        OracleConnection myconn = new OracleConnection(" Data Source=eocs ;user=CHEM;password=CHEM");
        myconn.Open();
        try
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //导入数据库代码

                string insertstr = "insert into YOUDUWUZHIFENBU values(:xh,:wzmc,:szdw,:wxtx,:ybcl)";

                OracleCommand myCmmd = new OracleCommand(insertstr, myconn);
                myCmmd.Parameters.Add(new OracleParameter("xh", OracleType.NVarChar, 40));
                myCmmd.Parameters.Add(new OracleParameter("wzmc", OracleType.VarChar, 40));
                myCmmd.Parameters.Add(new OracleParameter("szdw", OracleType.VarChar, 40));