Wait, isn't the Northwind Database a SQL Server database (or is this Access or VFP)? If it's SQL Server, you should be using SqlDataAdapter instead of the OleDbDataAdapter. Shouldn't make a difference, but maybe it is.
~~Bonnie
>>Rick,
>>
>>I haven't looked through all your code, but my first reaction to this is that you need to do an .EndEdit() or an .EndCurrentEdit(). Have you checked that MyDataSet.HasChanges() is returning a true?
>>
>>~~Bonnie
>----------------------
>Bonnie,
>
>I haven't done those things but I have tried simplifying the generated code to:
>UPDATE Employees SET
> LastName = "Brown_10"
>WHERE (EmployeeID = 10)
>
>And my
>UpdateResult = OleDbDataAdapterEmployees.Update(DSemployees1)
>still returns ZERO indicating that no records have been updated
>and an inspection of the Northwind Employees Table confirms this.
>(BTW - Yes, I do have a record where EmployeeID = 10 and that record's current last name is "Brown" not "Brown_10")
>
>Rick
>-----------------