基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

 

读取access数据库 并显示到报表中，可打印 可导出pdf和 导出 excel格式

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"]));
        }



    }
}