FastReport 绑定多个数据源

最新推荐文章于 2024-07-10 11:00:11 发布

s01896

最新推荐文章于 2024-07-10 11:00:11 发布

阅读量295

点赞数 2

分类专栏： FastReport 文章标签： c#

本文链接：https://blog.csdn.net/s01896/article/details/139278819

版权

FastReport 专栏收录该内容

3 篇文章 1 订阅

订阅专栏

using FastReport;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace FastReportTest
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt = DbHelperSQL.Query("SELECT *  FROM [LLFDB].[dbo].[computer]").Tables[0];

            DataSet data = new DataSet();
            //data = DbHelperSQL.Query("SELECT *  FROM [LLFDB].[dbo].[computer]");
            data.Tables.Add(dt.Copy());
            data.Tables[0].TableName = "computer";

            DataTable dt1 = DbHelperSQL.Query("SELECT *  FROM [LLFDB].[dbo].[t_button]").Tables[0];
            data.Tables.Add(dt1.Copy());
            data.Tables[1].TableName = "t_button";

            try
            {
                FastReport.Report report = new FastReport.Report();
                //string filename = @"C:\Documents and Settings\Administrator\桌面\检查项目.frx"; //报表文件路径
                string filename = "subreport.frx"; //报表文件路径
                report.Load(filename);   //如没有报表文件请注释此语句
                report.RegisterData(data); //注入DataTable 到报表
                //report.GetDataSource(data.Tables[0].TableName).Enabled = true;//报表取数据源
                //report.GetDataSource(data.Tables[1].TableName).Enabled = true;//报表取数据源
                FastReport.Utils.Res.LoadLocale("Chinese (Simplified).frl");//选择语言文件

                //DataBand dataa = report.Report.FindObject("Data1") as DataBand;
                //dataa.DataSource = report.Report.GetDataSource("computer");
                //dataa.DataSource = report.Report.GetDataSource("t_button");
                
                report.Show();//报表预览，
                //report.Design();  //设计报表
                FastReport.Utils.Config.PreviewSettings.Buttons = PreviewButtons.Print | PreviewButtons.Save | PreviewButtons.Navigator | PreviewButtons.PageSetup | PreviewButtons.Close;//打印预览中的菜单选择
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
        }
    }
}