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();
            custDB.Clear();
            CrystalReport1 myReport = new CrystalReport1();
            adap.Fill(custDB, "Customers");
            myReport.SetDataSource(custDB);
           // Set the Report Source to ReportView 
            crystalReportViewer1.ReportSource = myReport;
            conn.Close();