Hi,

I am having some problems using the .NET dataAdapter to insert/update a MSAccess2k database.

I add a new row to a dataset, then on calling the adapter update command, I get the following error

"No value given for one or more required parameters"

I've created the commandtext for the insert command:

VB Code:
  1. "INSERT INTO Customer(DOB, Employer, Surname, HealthNotes, MemberNumber, Occupat" & _
  2.                 "ion, PCityID, PhoneAH, PhoneBH, PhoneM, PPostCode, PStreetAddress, PSuburbID, Qu" & _
  3.                 "estionID, RCityID, RPostCode, RStreetAddress, RSuburbID, Sex, GivenName) VALUES (?" & _
  4.         ", ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

Anybody have experience here ?
Thanks,
BG