if (tbHerstellerName.Text.Length != 0)
{
oleDbConnection1.Open();
oleDbDataAdapter1.Fill(dataSet1);
oleDbConnection1.Close();

DataRow dtr = dataSet1.Tables["Hersteller"].NewRow();


dtr["Name"] = tbHerstellerName.Text.ToString();
dataSet1.Tables["Hersteller"].Rows.Add(dtr);
oleDbConnection1.Open();
oleDbDataAdapter1.Update(dataSet1, "Hersteller");
oleDbConnection1.Close();
tbHerstellerName.Clear();
}