asp.net中从数据库导出为excel问题

        //导出按钮事件
        protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
        {
            try
            {
                SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["constr"]);
                con.Open();
                string sql;
                if (this.dropdanwei.SelectedValue.ToString()== "" && dropxingzhi.SelectedValue.ToString()== "" &&                 dropzhengzhi.SelectedValue.ToString()== "")
                {
                    sql = "select 序号,姓名,性别,出生年月,身份证号,籍贯,文化程度,技术职称,参加工作日期,职务或工种,政治                  面貌,入党时间,单位名称,所在党支部,性质,状态,备注 from OFF_RenShi_ZhiGong ";
                }
                else
                {
                    sql = "select 序号,姓名,性别,出生年月,身份证号,籍贯,文化程度,技术职称,参加工作日期,职务或工种,政治                    面貌,入党时间,单位名称,所在党支部,性质,状态,备注 from OFF_RenShi_ZhiGong where 姓名" +                     Session["sql"] + "order by 序号 desc";
                }
                SqlCommand cmd = new SqlCommand(sql, con);
                SqlDataReader dr = cmd.ExecuteReader();
                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
                if (xlApp == null)
                {
                    Response.Write("can't open Excel");
                    return;
                }
                xlApp.Application.Workbooks.Add(true);
                int row = 3, filedount;
                filedount = dr.FieldCount;
                   string str1 = "123";      //这里的1123指的是标题

                 string[] strn = { "序号", "姓名", "性别", "出生年月", "身份证号", "籍贯", "文化程度", "技术职称", "参                加工作日期", "职务或工种", " 政治面貌", "入党时间", "单位名称", "所在党支部", "性质", "状态", "备注" };
                xlApp.Cells[1, 7] = str1.ToString();
                for (int col = 0; col < filedount; col++)
                {
                    xlApp.Cells[2, col + 1] = strn[col].ToString();
                }
                while (dr.Read())
                {
                    for (int col = 0; col < filedount; col++)
                    {
                        if (col == 0)
                        {
                            xlApp.Cells[row, col + 1] = "'" + dr.GetValue(col).ToString();
                        }
                        else
                            xlApp.Cells[row, col + 1] = dr.GetValue(col).ToString();
                    }
                    row++;
                }
                Response.Write("<script language=javascript>alert('导出成功！')</script>");
                xlApp.Visible = true;
                xlApp = null;
            }

            catch
            {
                Response.Write("<script language=javascript>alert('导出失败！请检查是否正确的选择查询条             件！')</script>");
            }

        }