using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Microsoft.Reporting.WebForms;namespace HumanpoolReport_V1._0.Reporting_Service
{
    public partial class 员工信息查询 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                
                {
                string frameHeight = "800px";
                this.ReportViewer1.Height = new Unit(frameHeight);
                this.ReportViewer1.Width = ReportCommon.ReportWidth;
                this.ReportViewer1.ProcessingMode = ProcessingMode.Remote;
                this.ReportViewer1.Drillthrough+=new DrillthroughEventHandler(ReportViewer1_Drillthrough);                string strReportRDL = "员工信息查询";
                string strReportServerURL = ReportCommon.ReportServerURL;
                string StandardReportPath = ReportCommon.StandardReportPath;
                this.ReportViewer1.ServerReport.ReportServerUrl = new Uri(ReportCommon.ReportServerURL.ToString());
                this.ReportViewer1.ServerReport.ReportPath = StandardReportPath + "/" + strReportRDL;                
                
                string 员工信息查询 = "员工信息查询";
                string EmName = Sql.Tostring(Request.QueryString["EmName"]);
                string TitleCN = Sql.Tostring(Request.QueryString["TitleCN"]);
                string IdCardCode = Sql.Tostring(Request.QueryString["IdCardCode"]);
                string Gender = Sql.Tostring(Request.QueryString["TitleCN as Gender"]);
                string Birthday = Sql.Tostring(Request.QueryString["Birthday"]);
                string Ewstatus = Sql.Tostring(Request.QueryString["Ewstatus"]);
                string CustomerName = Sql.Tostring(Request.QueryString["CustomerName"]);
                string ContactMobilePhone = Sql.Tostring(Request.QueryString["ContactMobilePhone"]);
                string ResidenceAddress = Sql.Tostring(Request.QueryString["ResidenceAddress"]);
                
    
                ReportParameter[] arrRptParameExport = new ReportParameter[]
                {
                    new ReportParameter("员工信息查询",员工信息查询),
                    new ReportParameter("EmName",EmName),
                    new ReportParameter("TitleCN",TitleCN),
                    new ReportParameter("IdCardCode",IdCardCode),
                    new ReportParameter("Gender",Gender),
                    new ReportParameter("Birthday",Birthday),
                    new ReportParameter("Ewstatus",Ewstatus),
                    new ReportParameter("CustomerName",CustomerName),
                    new ReportParameter("ContactMobilePhone",ContactMobilePhone),
                    new ReportParameter("ResidenceAddress",ResidenceAddress)
                };
                this.ReportViewer1.Visible = true;
                }
            
                
            }
        }
        protected void ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
        { 
        }
    }
}
提示当前上下文中不存在名称“SQL”该怎样修改,传入数据库里面的参数??这是报表的后台参数,让它可以在页面显示