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:

public void getUrlaub(SqlConnection conection)
        {
            try
            {
                conection.Open();
                string Sql = "Select * From  uservication";
                SqlDataAdapter dataAdapter = new SqlDataAdapter(Sql, conection);
                SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(dataAdapter);
                DataTable table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                dataAdapter.Fill(table);
                bindingSource1.DataSource = table;
                dataSet1.Tables.Add(table);
                dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
                conection.Close();
                
                dataGridView1.DataSource = bindingSource1;

            }
            catch (SqlException)
            {
                MessageBox.Show("To run this example, replace the value of the " +
                    "connectionString variable with a connection string that is " +
                    "valid for your system.");
            }
        }