เอา Code มาฝาก ASP.net Chart Connect MySql Database ^^

     <asp:Chart ID="Chart1" runat="server">
            <Series>
                <asp:Series Name="Series1">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>

String strConnString;
strConnString = "Server=localhost;User Id=root; Password=1234; Database=car-system; Pooling=false;Persist Security Info=True;Convert Zero Datetime=True ";
objConn = new MySqlConnection(strConnString);
objConn.Open();

string strSQL = "select booking_car, count( booking_car) as count from booking GROUP BY booking_car ;";

MySqlDataAdapter da = new MySqlDataAdapter(strSQL, objConn);
DataSet ds = new DataSet();
da.Fill(ds);

Chart1.DataSource = ds.Tables[0];
Chart1.Series["Series1"].ChartType = SeriesChartType.Column;
Chart1.Series["Series1"].IsValueShownAsLabel = true;
Chart1.Series["Series1"].IsValueShownAsLabel = true;
Chart1.Series["Series1"].XValueMember = "booking_car"; //เซ็ตให้แกน x เป็น colum "......"
Chart1.Series["Series1"].YValueMembers = "count";  //เซ็ตให้แกน Y เป็น colum "......"
Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false;  //ปิดเส้นแกน x
Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.Enabled = false;  //ปิดเส้นแกน Y
Chart1.DataBind();