Dynamic SQL Generation For The UpdateCommand Is Not Supported

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

I am getting the above error if i try to create a update command through a Command builder in .net cf on a SQLCE 3.0 database

The Select query I used for creating the update command is 'SELECT * FROM Users'


I populated a datatable with the above query through a DataAdapter, to check for the primary key and the primary key was available in the table. But still the CB could not able to create an Update Command for that query,

The Primary Key column that I use is of type GUID

Then when try to do the above job using a Typed DataSet with TableAdapters , then it throws the following error

'Update requires a valid UpdateCommand when passed DataRow Collection with modified rows'

can any one please tell me a way to fix this ,

Thanks and Regards
Varadan