Datenupdate mittels OleDbCommandBuilder

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

DataSet myDS = new DataSet();
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\db1.mdb"))
{
	// Daten auslesen
	OleDbDataAdapter adapter = new OleDbDataAdapter();
	adapter.SelectCommand = new OleDbCommand("SELECT ID, Vorname, Nachname FROM Kunden", conn);
	OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
	adapter.Fill(myDS, "Kunden");
	
	// Daten ändern
	myDS.Tables["Kunden"].Rows[0]["ID"] = 1;
	myDS.Tables["Kunden"].Rows[0]["Vorname"] = "Hans";
	myDS.Tables["Kunden"].Rows[0]["Nachname"] = "Harz";
	
	// Daten zurückschreiben               
	adapter.Update(myDS, "Kunden");
}