如何在C＃中使用mysql在visual studio 2015中使用水晶报表？ [英] How to use crystal report in visual studio 2015 in C# using mysql ?

问题描述

你好，我正在做一个打印条形码的应用程序，但我正在使用MySql挣扎于水晶报告......我做了一切必须要做的事情才能连接到mysql，创建数据集将它连接到Mysql等但我可以' t显示报告中表格的值...

需要帮助

谢谢。



我尝试过：



我使用Dot Connect Mysql将其连接到数据集，我可以看到值，但不是报告...

Hello, I am doing an application which will print barcodes but I am struggling with the crystal report using MySql... I did everything which must be done to connect to mysql , create dataset connect it to Mysql etc but I can't show the values of the table in the report...
Need some help
Thank you.

What I have tried:

I have used Dot Connect Mysql to connect it to the Dataset and I can see the values but not in the report...

推荐答案

您好，



请参考以下链接逐步实施，如果您发现任何疑问，请告诉我。







[ ^ ]



http://csharp.net-informations.com/crystal -reports / csharp-crystal-reports-stepbystep.htm [ ^ ]



谢谢

Hi there,

Please refer below link for step by step implementation,If you find any query then let me know.



[^]

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm[^]

Thanks

有没有办法清除那个报告 ？例如，我有一个文本框，在文本框中我放了条形码的副本数量，所以当我放入两个裸码副本时，当我更改副本数量时，它必须清除报告并放置新副本。 。

这是我的代码...

Is there a way to clear the report ? for example I have a textbox and in the textbox I put the numbers of copies of the barcode, so when I put two copies of the barecode, and when I change the number of copies it must clear the report and put the new copies...
Here is my code...

for (int i = 0; i < numericUpDown2.Value; i++)
            {               
                cmd = new MySqlCommand("SELECT ChaineEAN, PrixVente FROM tb_produits WHERE Designation ='" + CMB_Designation.Text+ "'", MyConnexion);
                MySqlDataAdapter s2 = new MySqlDataAdapter(cmd);

                s2.Fill(ds1, "tb_produits");

                ds1.WriteXmlSchema((System.IO.Path.GetTempPath() + "\\Tucano_DataBaseConnect.xsd"));



                crystal.Load(@"C:...\CrystalReportEAN.rpt");


                crystal.SetDataSource(ds1);

                CrystalReport.ReportSource = crystal;

有没有办法找到水晶报告的路径？我不想把C：.....放在负载中。

And is there a way to find the path to the crystal report ? I don't want to put C:..... in the load.

这篇关于如何在C＃中使用mysql在visual studio 2015中使用水晶报表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！