[ASP.NET]結合Crystal Report與DataSet XSD的應用

2009-03-18

27887
0
ASP.NET

最近討論區很多人在問crystal report的問題
小弟就多做一些範例,分享給大家呀.

首先準備好北風資料庫,下載

接下來先新增一個xsd檔(NORTHWND.xsd),當作Crystal Report的資料結構,如下圖所示(Products資料表)

再新增一個Crystal Report檔,資料庫專家選【專案資料→ADO.NET資料集→加入Products】,之後就是編輯報表了,如下圖所示

asp.net(c#)

GridViewCrystalReport.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewCrystalReport.aspx.cs" Inherits="GridViewCrystalReport" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>GridViewCrystalReport</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Label ID="Label2" runat="server" Text="ProductName："></asp:Label> <asp:TextBox ID="txbProductName" runat="server" Width="200px"></asp:TextBox> <asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_Click" Text="Search" /> <asp:Button ID="btnReport" runat="server" OnClick="btnReport_Click" Text="Report" /><br /> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2"> <Columns> <asp:TemplateField HeaderText="ProductID"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("ProductID") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="ProductName"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("ProductName") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="UnitPrice"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("UnitPrice") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="QuantityPerUnit"> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Eval("QuantityPerUnit") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> </div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NORTHWNDConnectionString %>" SelectCommand="SELECT * FROM [Products] WHERE ([ProductName] LIKE + @ProductName + '%')"> <SelectParameters> <asp:ControlParameter ControlID="txbProductName" Name="ProductName" PropertyName="Text" Type="String" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NORTHWNDConnectionString %>" SelectCommand="SELECT * FROM [Products]"></asp:SqlDataSource> </form> </body> </html>

GridViewCrystalReport.aspx.cs

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class GridViewCrystalReport : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnSearch_Click(object sender, EventArgs e) { if (this.txbProductName.Text.Trim() == "") { //使用沒條件的SqlDataSource this.GridView1.DataSourceID = this.SqlDataSource2.ID; } else { //使用有條件的SqlDataSource this.GridView1.DataSourceID = this.SqlDataSource1.ID; } } protected void btnReport_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); if (this.GridView1.DataSourceID == this.SqlDataSource1.ID) { dt = ((DataView)this.SqlDataSource1.Select(DataSourceSelectArguments.Empty)).ToTable(); } else { dt = ((DataView)this.SqlDataSource2.Select(DataSourceSelectArguments.Empty)).ToTable(); } //create CrystalReport object CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); //load report report.Load(Server.MapPath("CrystalReport.rpt")); //set data report.SetDataSource(dt); //export report.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.Excel, Response, true, "report.xls"); } }

執行結果：
1.查詢結果

2.滙出Excel

回首頁