Extract Month Wise Chart Report in ASP.Net

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