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”该怎样修改,传入数据库里面的参数??这是报表的后台参数,让它可以在页面显示
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”该怎样修改,传入数据库里面的参数??这是报表的后台参数,让它可以在页面显示
解决方案 »
- C#实现UDP的可靠传输
- 如何动态在一个FORM里面生成多个线程?多个线程可以同时调用一个过程吗?
- 如何返回一个日期所在星期的所有日期
- 如何在页面中运态加载多个FCKeditor控件?(C#)
- 基于outlook过滤收件人问题(C#)
- 求助
- 大家好,在mdi程序中,我把子窗口写在一个dll中,然后在mdi的程序中引用了这个dll,用using 引用了dll的namespace,然后调用那些子窗口可以实
- 怎么才能在启动一个chm帮助文件后,再启动这个chm文件时能够检测到已经有一个在运行了,并最大化这个chm截面,象普通帮助文件一样!
- 根据数据库查询结果控制Button的Enabled属性
- 送分58求软件
- 数据源如何更新
- Web开发C#语言开发
SQL是什么?没有看到定义
string EmName = Sql.Tostring(Request.QueryString["EmName"]);=》
string EmName = Request.QueryString["EmName"];