When I use the oAD.Update (Adapter command update) i get the folowing:
The Data Adapter.Select command parameter needs to be initialised.

I added in a :
oAD.SelectCommand = "Select * from mytable" but I get an error saying canot assign a string to an adapater....

This is happening in a Save Method of an Object, where I have the commandbuilders Insert,Update and Delete properties set. In a GetDataset method of the object I have following code:
OleDbDataAdapter oAd = new
OleDbDataAdapter("SELECT "+this.sFields+
" FROM "+this.sTableName,oCon);
which I presume is initializing a 'Select' property ?

I am unclear as to what the error message means . Is there a separate 'Select' property somewhere ?

Regards,

Gerard