C#

//server connections
            string hostname = "localhost";
            string username = "root";
            string password = "0000";
           
            // Define the database query    
            string mySelectQuery = "SELECT * FROM report;";

            // Create a database connection object using the connection string    
            MySqlConnection myConnection = new MySqlConnection("server=" + hostname + ";uid=" + username + ";pwd=" + password + ";database=elearning;Charset=latin1;");

            // Create a database command on the connection using query    
            MySqlCommand myCommand = new MySqlCommand(mySelectQuery, myConnection);

            // Set chart data source
            chart1.DataSource = myCommand;

            // Set series members names for the X and Y values 
            chart1.Series["Series 1"].XValueMember = "ExamNumber";
            chart1.Series["Series 1"].YValueMembers = "Percentage";

  
            chart1.DataBind();