1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:

        SqlConnection connection = new SqlConnection(connectionString);
            SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM tblBenutzer", connection);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
            builder.QuotePrefix = "[";
            builder.QuoteSuffix = "]";

            DataSet custDS = new DataSet();

            connection.Open();
            adapter.Fill(custDS, "tblBenutzera");

            custDS.Tables["tblBenutzera"].Rows[0][2] = "TEST";
            custDS.Tables["tblBenutzera"].PrimaryKey = new DataColumn[] { custDS.Tables["tblBenutzera"].Columns["ID"] };

            adapter.Update(custDS, "tblBenutzer");
            connection.Close();