How to set data to CrystalReport using MYSQL& C#

The following code sample shows how to set data to CrystalReport using MYSQL & C#.

using MySql.Data.MySqlClient;

MySqlConnection conn;
MySqlCommand cmd;
MySqlDataAdapter adap;

// Code to get data from database
conn = new MySqlConnection("Server=localhost; Database=test; User ID=root; Password=root; charset=utf8;"); conn.Open();
// cmd = conn.CreateCommand();
cmd = new MySqlCommand("demo", conn);
// cmd.CommandText = "SELECT customer_code, customer_name, customer_address FROM customers";
cmd.CommandType = CommandType.StoredProcedure;
// Create a Dataset and using DataAdapter to fill it
adap = new MySqlDataAdapter();
adap.SelectCommand = cmd;
CustomerDS custDB = new CustomerDS();
CrystalReport1 myReport = new CrystalReport1();
adap.Fill(custDB, "Customers");
// Set the Report Source to ReportView
crystalReportViewer1.ReportSource = myReport;


Author: Kapil Dhawan18 Jun 2008 Member Level: Gold   Points : 2

Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: