将MS Access Db动态连接到Crystal Report查看器 [英] Dynamicaly Connect The MS Access Db to Crystal Report viewer

问题描述

Hai我正在使用Ms Access数据库和Crystal Report Viewer ...现在我在运行时遇到一个新错误

Hai I am Using Ms Access Database and Crystal Report Viewer...Now I Got a one new error at runtime

CrystalReport_Receipt _Reportreceipt = new CrystalReport_Receipt();
                    _Reportreceipt.Load(AppDomain.CurrentDomain.BaseDirectory + "CrystalReport_Receipt.rpt");
                   _Reportreceipt.Database.Tables["tbl_Receipt"].Location = AppDomain.CurrentDomain.BaseDirectory + @"Datasource\Database_stock.accdb";
                   _Reportreceipt.Database.Tables["tbl_Invoiceproduct"].Location = AppDomain.CurrentDomain.BaseDirectory + @"Datasource\Database_stock.accdb";
                   _Reportreceipt.Database.Tables["tbl_customer"].Location = AppDomain.CurrentDomain.BaseDirectory + @"Datasource\Database_stock.accdb";
                   ParameterFieldDefinitions crParameterFieldDefinitions;
                   ParameterFieldDefinition crParameterFieldDefinition;
                   ParameterValues crParameterValues = new ParameterValues();
                   ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
                   crParameterDiscreteValue.Value = Qnumb;
                   crParameterFieldDefinitions = _Reportreceipt.DataDefinition.ParameterFields;
                   crParameterFieldDefinition = crParameterFieldDefinitions["Reciptno"];
                   crParameterValues = crParameterFieldDefinition.CurrentValues;
                   crParameterValues.Add(crParameterDiscreteValue);
                   crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
                   crystalReportViewer1.ReportSource = _Reportreceipt;

我的错误是:

My Error is:

Failed to load database information.
Error in File temp_34fd2248-2924-40b0-acc9-7940eb9e0ce4 {53BF7938-282D-409A-B6DE-6B58DDCF3029}.rpt:
Failed to load database information.

请解决我的问题，请回答我

Please Solve My Problem Please Reply Me

推荐答案

，当您收到上述错误时? 顺便说一句，为什么到处都提到DB?提及一次，然后使用其引用.我还使用过MS Access DB，我将要显示的记录保存在数据表中并转发给报表查看器.还创建数据集并设置列名称.使用数据库专家，我可以获取Crystal Report中的所有列并轻松显示记录.

when you are getting this above error??
by the way why you are mentioning you DB everywhere? mention it once and then use its reference. I have also worked with MS Access DB, i have saved the records which i want to display in a datatable and forward to report viewer. Also create dataset and set column name. Using Database Expert i am getting all the columns in Crystal Report and easily display the record.

i解决了此问题，我将数据库保存为2007 accdb格式，因此该格式无法以上代码的访问运行时间...因此，请在您的Access Db中转换mdb格式，并运行程序，这是正确执行的

i Solve This Problem ,I Save My DB in 2007 accdb Format ,So This Format can''t Access Run time for Above Coding...... So u Convert mdb Format in your Access Db,and run the Program This is Execute Correctly

这篇关于将MS Access Db动态连接到Crystal Report查看器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！