using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
    public partial class Teilnehmeranzeigen : Form
    {
        private static string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=H:\\vs\\WindowsFormsApplication2\\WindowsFormsApplication2\\TeilnehmerITB731.mdb";

        public Teilnehmeranzeigen()
        {
            InitializeComponent();
            //CreateCommand("Select count(*) from Teilnehmer;", connectionString);
            CreateTeilnehmerlist(connectionString);
            LabelText(connectionString);
        }
        private void CreateTeilnehmerlist(string connectionString)
        {
            try
            {
                using (OleDbConnection connection = new OleDbConnection(connectionString))
                {
                    connection.Open();
                    OleDbCommand dataCommand = connection.CreateCommand();
                    dataCommand.Connection = connection;
                    dataCommand.CommandText = "SELECT Vorname + ' ' + Name AS Teilnehmername FROM Teilnehmer ORDER BY Name";
                    OleDbDataReader dataReader = dataCommand.ExecuteReader();

                    while (dataReader.Read())
                    {
                        lbTeilnehmerliste.Items.Add(dataReader.GetString(0));
                    }
                    connection.Close();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
        private void LabelText(string connectionString)
        {
            try
            {
                using (OleDbConnection connection = new OleDbConnection(connectionString))
                {
                    connection.Open();
                    OleDbCommand dataCommand = connection.CreateCommand();
                    dataCommand.Connection = connection;
                    dataCommand.CommandText = "Select count(*) from Teilnehmer;";

                    OleDbDataReader dataReader = dataCommand.ExecuteReader();
                    dataReader.Read();
                    label1.Text = string.Format("Es sind {0} Teilnehmer gemeldet:", dataReader.GetValue(0).ToString());
                    connection.Close();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
    }
}