多表头excel导入问题，在线等，

Question

  private void InputExcel(string pPath)
        {            string conn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + pPath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";            OleDbConnection oleCon = new OleDbConnection(conn);            oleCon.Open();            string Sql = "select * from [Sheet$]";            OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, oleCon);            DataSet ds = new DataSet();            mycommand.Fill(ds, "[Sheet$]");            oleCon.Close();
            int count = ds.Tables["[Sheet$]"].Rows.Count;
            int colcunt=ds.Tables["[Sheet$]"].Columns.Count;
            
            EarthView.BLL.GLSP_HYHJGLQKJB_HJZFTJ_QFTJ bll = new BLL.GLSP_HYHJGLQKJB_HJZFTJ_QFTJ();
            int TabCount=bll.Count();
            //TabCount = TabCount;
            if (TabCount == colcunt)
            {
                for (int i = 3; i < count; i++)
                {
                    EarthView.Model.GLSP_HYHJGLQKJB_HJZFTJ_QFTJ model = new Model.GLSP_HYHJGLQKJB_HJZFTJ_QFTJ();                    //model.TBDW = ds.Tables["[Sheet$]"].Rows[i]["填报单位"].ToString().Trim();
                    //model.JCQFXM = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["检查倾废项目（个）"].ToString().Trim());
                    //model.XSQDQ = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["巡视倾倒区（个）"].ToString().Trim());
                    //model.DJQFC = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["登检倾废船（艘）"].ToString().Trim());
                    //model.JCQFZ = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["检查倾废证（个）"].ToString().Trim());
                    //model.LDJC = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["陆地检查次数（次）"].ToString().Trim());
                    //model.HSJC = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["海上检查次数（次）"].ToString());
                    //model.KZJC = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["空中检查次数（次）"].ToString());
                    //model.WZQD = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["无证倾倒"].ToString());
                    //model.BAXKZGDQD = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["不按许可证规定倾倒"].ToString().Trim());
                    //model.BAGDJLQD = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["不按规定记录倾倒"].ToString().Trim());
                    //model.QTWFXW = Convert.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["其他"].ToString().Trim());
                    //model.WFJE = ,.ToInt32(ds.Tables["[Sheet$]"].Rows[i]["处罚金额（万元）"].ToString().Trim());
                    //model.WFXWDCCL = ds.Tables["[Sheet$]"].Rows[i]["违法行为调查和处理情况"].ToString().Trim();                    // string excelsql = "insert into " + this.UserInfo.Company + "..[resak] (resak001, resak002, resak015,resak005,resak013,resak009) values ('" + tUserID + "','" + tUserName + "','" + tDept + "','" + tEmail + "','" + tLeader + "','" + tAngent + "')";
                   // EarthView.BLL.YB_YSJ_QDQSY bll = new BLL.YB_YSJ_QDQSY();
                    bll.Add(model);
                    this.Response.Write("<script>window.opener.location.href=window.opener.location.href;window.close();</script>");
                    this.Response.Write("<script>window.opener.location.href='YBYSJQFZF.aspx';</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('请核对字段数目是否正确！')</script>");
            }        }

Answer 1

                            <dx:GridViewDataTextColumn Caption="检查倾废证（个）" FieldName="JCQFZ" VisibleIndex="5">
                                <HeaderStyle HorizontalAlign="Center" />
                                <CellStyle HorizontalAlign="Center">
                                </CellStyle>
                            </dx:GridViewDataTextColumn>
                            <dx1:GridViewBandColumn Caption="检查次数（次）" HeaderStyle-HorizontalAlign="Center" VisibleIndex="6">
                                <Columns>
                                    <dx:GridViewDataTextColumn Caption="陆地检查次数（次）" FieldName="LDJC"
                                        Width="150">
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <CellStyle HorizontalAlign="Center">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="海上检查次数（次）" FieldName="HSJC"
                                        Width="150">
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <CellStyle HorizontalAlign="Center">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="空中检查次数（次）" FieldName="KZJC"
                                        Width="150">
                                        <HeaderStyle HorizontalAlign="Center" />
                                        <CellStyle HorizontalAlign="Center">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                </Columns>
                            </dx1:GridViewBandColumn>