如何使用c＃wpf应用程序从数据集中显示水晶报表中的数据？ [英] How to display data in crystal report from dataset using c# wpf application?

问题描述

您好，



我在水晶报表中使用此代码显示数据，但数据不显示数据集数据，仅显示水晶报表参数或文本框数据。



如何使用c＃在水晶报表中显示数据？

我的代码： -

Hello,

I am using this code for display data in crystal report but data its not displaying only dataset data, its displaying only crystal report parameter or textbox data.

How will be display data in crystal report using c#?
My code:-

SqlConnectionClass conString = new SqlConnectionClass();
            SqlCommand cmd = new SqlCommand("procGeneratePDF", conString.GetConnection());
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@InvoiceNumber", SqlDbType.Int).Value = InvoiceNum;
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(ds);

ReportDocument InvoiceReportDocument = new ReportDocument();

InvoiceReportDocument.Load("../../InvoiceReport.rpt");
            InvoiceRep.SetDataSource(ds);
            InvoiceRep.SetParameterValue("CustomerName", cmbCustomer.Text);
            InvoiceRep.SetParameterValue("CustomerAddress", txtCustomerAdd.Text);
            InvoiceRep.SetParameterValue("CustCIty", txtCity.Text);
            InvoiceRep.SetParameterValue("CustState", txtState.Text);
            InvoiceRep.SetParameterValue("CustPIN", txtPin.Text);
            InvoiceRep.SetParameterValue("CustCountry", txtCountry.Text);
            InvoiceRep.SetParameterValue("CustInvoiceNumber", txtInvoiceNumber.Text);
            InvoiceRep.SetParameterValue("ProjPORef", txtPORef.Text);
            InvoiceRep.SetParameterValue("CustVendorCode", txtVendorCode.Text);
ExportInvoicePDF();

但数据仅显示在数据集中。



和我也出口到pdf。

But data displaying in dataset only.

and I am also exporting to pdf also.

public void ExportInvoicePDF()
       {
           InvoiceRep.SetDatabaseLogon("", "", @".\SQLEXPRESS", "abc");
           ExportOptions InvoiceExportOptions;
           DiskFileDestinationOptions InvoiceDiskFileDestinationOptions = new DiskFileDestinationOptions();
           PdfRtfWordFormatOptions InvoiceFormatTypeOption = new PdfRtfWordFormatOptions();
           if (!Directory.Exists(@"c:\abc\Invoices"))
               Directory.CreateDirectory(@"c:\abc\Invoices");
           InvoiceDiskFileDestinationOptions.DiskFileName = @"c:\abc\Invoices\" + txtInvoiceNumber.Text + ".pdf";
           InvoiceExportOptions = InvoiceRep.ExportOptions;
           {
               InvoiceExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
               InvoiceExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
               InvoiceExportOptions.ExportDestinationOptions = InvoiceDiskFileDestinationOptions;
               InvoiceExportOptions.ExportFormatOptions = InvoiceFormatTypeOption;
           }
           InvoiceRep.Export();
           MessageBox.Show("Invoice is exported at c:\\abc\\Invoices\\" + txtInvoiceNumber.Text + ".pdf", "Information");
       }

我使用参数化存储过程。
当我导出时
提交到pdf，以便在InvoiceRep.Export中出现geeting错误

错误是： - 缺少参数值。



请帮帮我。

提前致谢。

I am using parameterized stored procedure.
when i export file in to the pdf so its geeting error in "InvoiceRep.Export"
error is:- Missing parameter value.

Please help me.
Thanks in advance.

推荐答案

First check no of parameters you pass & no in he report & use this code

SqlConnectionClass conString = new SqlConnectionClass();
            SqlCommand cmd = new SqlCommand("procGeneratePDF", conString.GetConnection());
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@InvoiceNumber", SqlDbType.Int).Value = InvoiceNum;
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(ds);
 
ReportDocument InvoiceReportDocument = new ReportDocument();
 
InvoiceReportDocument.Load("../../InvoiceReport.rpt");
           
            InvoiceRep.SetParameterValue("CustomerName", cmbCustomer.Text);
            InvoiceRep.SetParameterValue("CustomerAddress", txtCustomerAdd.Text);
            InvoiceRep.SetParameterValue("CustCIty", txtCity.Text);
            InvoiceRep.SetParameterValue("CustState", txtState.Text);
            InvoiceRep.SetParameterValue("CustPIN", txtPin.Text);
            InvoiceRep.SetParameterValue("CustCountry", txtCountry.Text);
            InvoiceRep.SetParameterValue("CustInvoiceNumber", txtInvoiceNumber.Text);
            InvoiceRep.SetParameterValue("ProjPORef", txtPORef.Text);
            InvoiceRep.SetParameterValue("CustVendorCode", txtVendorCode.Text);

 InvoiceRep.SetDataSource(ds);

ExportInvoicePDF();

这篇关于如何使用c＃wpf应用程序从数据集中显示水晶报表中的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！