Insert into Access DB Using DataSet

[Sarathi]

Hi...
Here is my code and my problem is that it doesn't update DB.
Langauage Used : C#
OleDbAdapter customerDA= new OleDbAdapter("Select * from
Cusomers",connection);
DataSet customerDS = new DataSet();
customerDA.Fill(customerDS);

DataRow customerRow = customerDS.Tables[0].NewRow();
customerRow["Name"] = "Kris";
customerDS.Tables[0].Rows.Add(customerRow);
customerDA.Update(customerDS.Tables[0].Select(null,null,DataViewRoState.Adde
d);
connection.close();

 

[Gerben van Loon]

Don't you need to set the dataadapters .InsertCommand?

greets