How to use crystal report in visual studio 2015 in C#

Jim Tat

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jim Tat10y ago
Is there a way to clear the report ? for example I have a numericUpDown and in the numericUpDown 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(inti=0;i<numericUpDown2.Value;i++)
{
cmd=newMySqlCommand("SELECTChaineEAN,PrixVenteFROMtb_produitsWHEREDesignation='"+CMB_Designation.Text+"'",MyConnexion);
MySqlDataAdapters2=newMySqlDataAdapter(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.
Jim Tat10y ago
Hi, I want to use MYSQL is it the same like SQL ?
Bikesh Srivastava10y ago
I think you can use SSRS instead of crystel report.
Karthikeyan K10y ago
Hi,
Check with Report Wizard, Please find the below link.
http://www.c-sharpcorner.com/UploadFile/66489a/report-wizard-in-visual-studio-2015/