sqlcon.Open();
            SqlDataAdapter sqlda = new SqlDataAdapter("SELECT * FROM Events WHERE  FixtureID = " + ddlFixture.SelectedValue, sqlcon);
            DataSet ds = new DataSet();
            sqlda.Fill(ds);
            BarChart1.Visible = true;
            string[] count = new string[4];
            String[] events = new string[4];

            if (ds.Tables[0].Rows.Count > 0)
            {

                count[0] = ds.Tables[0].Rows[0]["EventName"].ToString();
                count[0] = ds.Tables[0].Rows[0]["EventName"].ToString();
                count[0] = ds.Tables[0].Rows[0]["EventName"].ToString();
                events[0] = "Free";
                events[1] = "Goal";
                events[2] = "Wide Shot";

            }
            sqlcon.Close();
            BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries { Data = events });
            BarChart1.CategoriesAxis = string.Join(",", events);
            BarChart1.ChartTitle = "Stats Graph";