How to use crystal report in visual studio 2015 in C# using mysql ?

Question

0.00/5 (No votes)

See more:

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...

Posted 6-Oct-16 4:41am

TatsuSheva

Updated 10-Oct-16 23:34pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Paresh_Kapuriya · Answer 1 · 2016-10-07T00:17:00

Solution 1

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

Posted 7-Oct-16 0:17am

Paresh_Kapuriya

Comments

TatsuSheva 7-Oct-16 6:18am

There is no picture there... Did you try it before ?

Paresh_Kapuriya 7-Oct-16 6:24am

yes. i have tried it.. and also implented same thing.

which verions of visual studion and crystal report are you using ?

TatsuSheva 7-Oct-16 6:59am

Visual Studio: VS Community 2015 , crystal report 13.

TatsuSheva · Answer 2 · 2016-10-10T23:34:00

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...

C#

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;

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