Hi, Gerard-
>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....
Just to add an explicit explanation for this, the SelectCommand property takes a Command _object_, not a string. The Command object then has a string property called SelectText. You don't pass the Select text and connection to the OleDbDataAdapter's constructor, but to the Command object's constructor. For example:
string selectText = "SELECT "+this.sFields+" FROM "+this.sTableName
DataAdapter dataAdapter = new DataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(selectText, oCon);
The DataAdapter has several associated command members: select, update, and insert.
HTH