ReportViewer的动态绑定
来源:互联网 发布:js 刷新本页 编辑:程序博客网 时间:2024/06/10 03:50
aspx页面关键代码 代码
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<uc2:StatementQuery ID="StatementQuery1" runat="server" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="View Report" />
<asp:Button
ID="Button2" runat="server" Text="Button" onclick="Button2_Click" />
<asp:TextBox ID="txtParameter" runat="server"></asp:TextBox>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
>
<LocalReport ReportPath="statement/Report_Metal.rdlc" >
<DataSources>
<rsweb:ReportDataSource />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
</form>
</body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<uc2:StatementQuery ID="StatementQuery1" runat="server" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="View Report" />
<asp:Button
ID="Button2" runat="server" Text="Button" onclick="Button2_Click" />
<asp:TextBox ID="txtParameter" runat="server"></asp:TextBox>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
>
<LocalReport ReportPath="statement/Report_Metal.rdlc" >
<DataSources>
<rsweb:ReportDataSource />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
</form>
</body>
C#关键代码
代码
private void BindReportViewer()
{
BusinessLogic.MetalStatViewCollection MSVCOLL = new BusinessLogic.MetalStatViewCollection();
MSVCOLL = BusinessLogic.MetalStatViewCollection.getMetalStatViewCollection("year=2009 and month=12 and day=3");
IList<rMSV> MSVList = new List<rMSV>();
foreach (MetalStatView m in MSVCOLL)
{
MSVList.Add(new rMSV(m.GroupField, m.clientName, m.weight, m.amount));
}
ReportDataSource rds = new ReportDataSource("DataSet_Metal_DataTableMetal", MSVList);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
}
{
BusinessLogic.MetalStatViewCollection MSVCOLL = new BusinessLogic.MetalStatViewCollection();
MSVCOLL = BusinessLogic.MetalStatViewCollection.getMetalStatViewCollection("year=2009 and month=12 and day=3");
IList<rMSV> MSVList = new List<rMSV>();
foreach (MetalStatView m in MSVCOLL)
{
MSVList.Add(new rMSV(m.GroupField, m.clientName, m.weight, m.amount));
}
ReportDataSource rds = new ReportDataSource("DataSet_Metal_DataTableMetal", MSVList);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
}
需要用dataset的XSD文件作为中转。
详细过程,可以参考:http://www.codeproject.com/kb/aspnet/ReportViewer.aspx
以前按照MSDN的指导,有成功使用过动态绑定RDLC,可这次使用到业务对象,并用ObjectDataSource来作为数据源的中转,结果搞了几天,也总是有问题。
后来,重头来过,不用ObjectDataSource,按codeproject上的简单例子,实现了动态绑定,再将我们要使用的业务对象加上去,通过XSD来中转,一样完成了目标功能。
http://four-corner.appspot.com/
http://anforen.5d6d.com/
- ReportViewer的动态绑定
- ReportViewer 动态绑定
- ReportViewer 动态绑定
- 动态绑定数据源的ReportViewer终于搞定了
- ReportViewer之使用,多rdlc与单ReportViewer的绑定
- 一个reportviewer 动态加载不同的report
- reportviewer动态数据源
- reportviewer动态数据源
- ReportViewer动态加载报表文件
- 动态绑定的关键
- Java的动态绑定
- 动态绑定的例子
- java的动态绑定
- JAVA的动态绑定
- Java的动态绑定
- java的动态绑定
- C++的动态绑定
- 动态绑定的内幕
- C#操作Excel(一)
- Second-price Auction
- PCM音频文件(.wav)压缩成GSM6.10(.wav)
- 读取某一文件夹下的所有文件
- 开发者不可不知的PHP框架深度解析
- ReportViewer的动态绑定
- windows.h winsock2.h winsock.h的关系
- 如何利用JDownloads在首页导航栏中添加一个链接
- Oracle创建表空间/表分区
- 挫折不是惩罚,而是学习的机会
- test
- android sqlite
- 重载new[]和delete[]示例
- 我安家了