Generate monthly report using dropdown list
Chart1.Visible = true;
//Mysql conncectio add conncetion
DataTable ds = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter("select * from tablename WHERE month(date) ='" + DropDownList1.Text + "'", con);
da.Fill(ds);
Chart1.DataSource = ds;
Chart1.ChartAreas[0].AxisX.Interval = 1
This code works