Make sure you are including the primary key in your select statement. What does your UpdateCommand look like?
>Hi,
>
>Is it possible to use the SqlDataAdapter.Update() using a SqlCommandBuilder object to generate the update commands without setting a PK on a table in SQL server?
>
>I tried specifying the PrimaryKey property on the Table object but that didn't work.
>
>Thanks,
>
>Michael Henstock
>AWS