日期:2014-05-20 浏览次数:21358 次
//设置数据源信息
        DataSet1 ds1 = new DataSet1();
        OleDbDataAdapter da = new OleDbDataAdapter();
        String connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath ("~/app_data/test.mdb")+";";
        OleDbConnection cn = new OleDbConnection(connstr);
        //获取记录集,注意,最终获取的记录集需要与xsd的结构一致!      
        da = new OleDbDataAdapter("SELECT EmployeeId1 as EmployeeId,EmployeeName1 as EmployeeName From Employee1", cn);
        da.Fill(ds1, "Employee");
        //把本地图片先写入到数据集
        //将图片读到stream,并转换为byte[]
        //图片1
        FileStream fs1 = new FileStream(@"c:\1.bmp", FileMode.Open, FileAccess.Read);
        BinaryReader br1 = new BinaryReader(fs1);        
        byte[] bt1 = br1.ReadBytes((int)fs1.Length);
        //图片2
        FileStream fs2 = new FileStream(@"c:\a2.jpg", FileMode.Open, FileAccess.Read);
        BinaryReader br2 = new BinaryReader(fs2);
        byte[] bt2 = br2.ReadBytes((int)fs2.Length);
        
        fs1.Close();
        fs2.Close();
        //写入到ds1中(仅1行)
        ds1.myLogo.AddmyLogoRow(bt1, bt2);
       
        //以上为数据部分,与报表无关
        //-----------------------
        //以下为报表部分
        //使用报表对象加载报表
        
        string reportPath = Server.MapPath("~/app_data/crystalreport1.rpt");
        myReport.Load(reportPath);
        //绑定数据集,注意,一个报表用一个数据集。
        myReport.SetDataSource(ds1);
        CrystalReportViewer1.ReportSource = myReport;