1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:

    private void button1_Click(object sender, EventArgs e)
        {

            System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection();
            connection.ConnectionString = XXXXXXXXXXXX;
            SqlCommand SqlCommand = new SqlCommand ("Select * from Mitarbeiter",connection);
            List<String> liste = new List<String>();

            try
            {
                connection.Open();

                SqlDataReader reader = SqlCommand.ExecuteReader();
              

                while (reader.Read())
                {
                    liste.Add(reader["Vorname"].ToString()); 
                    liste.Add(reader["Nachname"].ToString());
                    liste.Add(reader["Telefonnr"].ToString());
                }

            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

            finally
            {
                connection.Close();
            }

           for(int i=0; i<liste.Count; i++)
           {
               label1.Text += liste[i].ToString()+"\n"; 
           }


        }
    }					

1:
2:
3:
4:
5:
6:

class Person
{
  public string Vorname { get; set; }
  public string Nachname { get; set; }
  public string TelefonNummer { get; set; }
}					

1:

List<Person> liste = new List<Person>();					

1:
2:
3:
4:
5:
6:
7:
8:
9:

while (reader.Read())
{
    Person person = new Person();
    person.Vorname = reader["Vorname"].ToString();
    person.Nachname = reader["Nachname"].ToString();
    person.Telefonnummer = reader["Telefonnr"].ToString();

    liste.Add(person);
}