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:

using (SqlConnection sqlConnection = new SqlConnection(Properties.Settings.Default.ConnectionString))
{
  sqlConnection.Open();

  try
  {
    SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("Select * From Students", sqlConnection);
    DataSet dataset = new DataSet();
    sqlDataAdapter.FillSchema(dataset, SchemaType.Source, "Students");
    DataTable channelSetTable = dataset.Tables["Students"];

    // Neuen Schüler anlegen
    DataRow newRow = channelSetTable.NewRow();
    newRow["Forename"] = "Max";
    newRow["Surname"] = "Mustermann";
    newRow["Birthdate"] = DateTime.Parse("18.01.1995");
    channelSetTable.Rows.Add(newRow);

    // In DB überführen
    dataset.AcceptChanges();
    sqlDataAdapter.Update(channelSetTable);
  }
  finally
  {
    sqlConnection.Close();
  }
}