FastReport studio 动态加载数据集

测试使用的FastReport Studio 版本为4.6.80

先引用FastReport.dll

然后把C:\Program Files\FastReports\FastReport Studio Trial\Examples\VisualC#.NET\DataSetDemo目录下的

FrxDataSet.cs

FrxDataTable.cs

FrxDataTable.resx

复制到解决方案中(切记要将这三个文件代码中的命名空间更改为自己程序的命名)

SQLServer数据库，表名demo_test 有三个字段 id(int),name(char),onemorename(char)

FastReport报表demo_test.fr3中有三个memo

[demo_test."id"] DataField属性 id

[demo_test."name"] DataField属性 name

[demo_test."onemorename"] DataField 属性 onemorename

以下是我根据DataSetDemo写的代码，在VS2005中测试通过

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using FastReport; using System.Data.SqlClient; namespace FRDemoTest { public partial class Form1 : Form { TfrxReportClass report; FrxDataTable datatable; FrxDataSet dataset; public Form1() { InitializeComponent(); } //为FrxDataTable加载数据 private void FillTableWithSampleData(FrxDataTable datatable) { SqlConnection conn = new SqlConnection("server=.;database=DEMO;UID=sa;PWD="); SqlDataAdapter da = new SqlDataAdapter("select * from demo_test", conn); da.Fill(datatable); } //为FrxDataSet加载数据 private void FillDataSetWithSampleData(FrxDataSet dataset) { SqlConnection conn = new SqlConnection("server=.;database=DEMO;UID=sa;PWD="); SqlDataAdapter da = new SqlDataAdapter("select top 2 * from demo_test", conn); da.Fill(dataset,"demo_test");\\demo_test为表名,对应FastReport模板中Memo的名字[demo_test."id"] } //加载FrxDataTable private void button1_Click(object sender, EventArgs e) { report = new TfrxReportClass(); report.ClearDatasets();//加这句可以避免重复打开报表提示错误 datatable = new FrxDataTable("demo_test");\\demo_test为表名,对应FastReport模板中Memo的名字[demo_test."id"] FillTableWithSampleData(datatable); //report.MainWindowHandle = (int)this.Handle; report.LoadReportFromFile("demo_test.fr3"); //report.ClearDatasets(); datatable.AssignToReport(true, report); datatable.AssignToDataBand("MasterData1", report); report.ShowReport(); } //加载FrxDataSet private void button2_Click(object sender, EventArgs e) { report = new TfrxReportClass(); report.ClearDatasets(); //加这句可以避免重复打开报表提示错误 dataset = new FrxDataSet(); FillDataSetWithSampleData(dataset); report.LoadReportFromFile("demo_test.fr3"); dataset.BindToReport(report); dataset.BindTableToBand("demo_test", report, "MasterData1"); report.ShowReport(); } //加载Dedigner private void button3_Click(object sender, EventArgs e) { report = new TfrxReportClass(); report.LoadReportFromFile("demo_test.fr3"); report.DesignReport(); } } }