SQL Server & DataSets ?? Key Column Info ?

i've just started developing using sql server & vb.net

and am slowly learning about ado rather than dao but my question is this

im using vb.net & i have some code using a OleDbDataAdapter, OleDbConnection, OleDbCommand and a DataSet

but when i try n update records on the database i keep getting the error

Dynamic generation of SQL cannot be done . . . .

because no key column information was selected ???

whats key column information its really starting to do my head in :(

How are you updating them ??

With recordset, updatestatement ??

using the myDataAdapter.update command

and passing in the dataset

Does your table have a primary key?

Primary Key

im using the one column as a Unique ID but its not set as the primary key

ill give it a goe see if it works [;)]