SELECT zh, ah, a, b, c, classname, units, application_t, charge, number, model, st, et, sa, ea, task, instructions, zod_attendant, zhd_attendant, status, id, Expr1, Expr2, official, sn FROM dbo.report where Expr1='37'-------------------------------------------
问题1:reportviewer+rdlc+aspx之间如何传值,能否把条件语句后在的37改为变量(取aspx页面传过来的值做为变量)...;
2:如果不能,有没有其它解决办法...
也就是点击aspx页面上的一条记录,reportviewer+rdlc控件就可以调出该条记录,且只有该条记录(打印或导出PDF-EXECL)..
谢谢!
附:xsd文件--------------------------------<?xml version="1.0" encoding="utf-8"?> </Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="reportTableAdapter" GeneratorDataComponentClassName="reportTableAdapter" Name="report" UserDataComponentName="reportTableAdapter">
<MainSource>
<DbSource ConnectionRef="conn (Web.config)" DbObjectName="vehicles_d.dbo.report" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT zh, ah, a, b, c, classname, units, application_t, charge, number, model, st, et, sa, ea, task, instructions, zod_attendant, zhd_attendant, status, id, Expr1, Expr2, official, sn FROM dbo.report where Expr1='37'</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="zh" DataSetColumn="zh" />
.............................
省略N行
............................ </Mappings>
问题1:reportviewer+rdlc+aspx之间如何传值,能否把条件语句后在的37改为变量(取aspx页面传过来的值做为变量)...;
2:如果不能,有没有其它解决办法...
也就是点击aspx页面上的一条记录,reportviewer+rdlc控件就可以调出该条记录,且只有该条记录(打印或导出PDF-EXECL)..
谢谢!
附:xsd文件--------------------------------<?xml version="1.0" encoding="utf-8"?> </Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="reportTableAdapter" GeneratorDataComponentClassName="reportTableAdapter" Name="report" UserDataComponentName="reportTableAdapter">
<MainSource>
<DbSource ConnectionRef="conn (Web.config)" DbObjectName="vehicles_d.dbo.report" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT zh, ah, a, b, c, classname, units, application_t, charge, number, model, st, et, sa, ea, task, instructions, zod_attendant, zhd_attendant, status, id, Expr1, Expr2, official, sn FROM dbo.report where Expr1='37'</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="zh" DataSetColumn="zh" />
.............................
省略N行
............................ </Mappings>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货