private void Question_16_Load(object sender, EventArgs e)
{
var dbConnection = DB.Instance();
dbConnection.DatabaseName = "respuestas";
if (!dbConnection.IsConnect())
{
MessageBox.Show("Hay un error con la base de Datos", "Información");
}
MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT XVI as valor, COUNT(*) as cantidad FROM respuestas GROUP BY XVI", dbConnection.Connection);
DataTable table = new DataTable();
adapter.Fill(dataSet1);
table = dataSet1.Tables[0];
List <QuestionNumerical> list = Convertions.ConverToListNumerical(table);
chartControl1.Series[0].DataSource = list;
chartControl1.Series[0].ArgumentDataMember = "valor";
chartControl1.Series[0].ValueDataMembers.AddRange(new string[] { "cantidad" });
chartControl1.Series[0].Label.TextPattern = "{V}";
chartControl1.Series[0].LegendTextPattern = "{A}";
}