Esempio n. 1
0
        private void Question_13_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 xiii.valor, COUNT( * ) as cantidad FROM respuestas INNER JOIN xiii ON respuestas.XIII = xiii.clave GROUP BY XIII", dbConnection.Connection);
            DataTable        table   = new DataTable();

            adapter.Fill(dataSet1);

            table = dataSet1.Tables[0];

            List <Questions> list = Convertions.ConvertoToList(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} ({VP:p0})";
            chartControl1.Series[0].LegendTextPattern = "{A}";
        }