c# 报表 分页/打印/导出源码(access数据库)

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace RDLCSR
{
    public partial class frmMain : Form
    {
        public frmMain()
        {
            InitializeComponent();
        }


        private DataSet dsOrders;



        private void frmMain_Load(object sender, EventArgs e)
        {
            this.rptMain.LocalReport.SubreportProcessing  = new Microsoft.Reporting.WinForms.SubreportProcessingEventHandler(SubReportProcessingEventHandler);

            this.dsOrders = new DataSet();
            this.dsOrders.Tables.Add("Order");
            this.dsOrders.Tables.Add("OrderDetails");
            System.Data.OleDb.OleDbDataAdapter oda =
                new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM 订单",
                "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="   Application.StartupPath   @"\Northwind.mdb");
            oda.Fill(this.dsOrders.Tables["Order"]);
            oda.SelectCommand.CommandText = "SELECT * FROM 订单明细";
            oda.Fill(this.dsOrders.Tables["OrderDetails"]);
            this.rptMain.LocalReport.DataSources.Add(
                new Microsoft.Reporting.WinForms.ReportDataSource("DataOrder_订单",
                this.dsOrders.Tables["Order"]));
            
            this.rptMain.RefreshReport();

            
            //this.rptMain.RefreshReport();
        }


        private void SubReportProcessingEventHandler(object sender, Microsoft.Reporting.WinForms.SubreportProcessingEventArgs e)
        {
            e.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataOrder_订单明细", this.dsOrders.Tables["OrderDetails"]));
            //e.DataSources.Add(new ReportDataSource("DataOrder_订单明细", this.dsOrders.Tables["OrderDetails"]));
        }



    }
}