Hi Tim,

If I do the following :-

     EDBDataAdapter adap = new EDBDataAdapter("select * from occupation",
con);
     EDBCommandBuilder cb = new EDBCommandBuilder(adap);
     cb.GetUpdateCommand();

.... an InvalidOperationException is thrown which says "SelectCommand
property needs to be initialized."

If I do the following then it's ok :-

     EDBDataAdapter adap = new EDBDataAdapter("select * from occupation",
con);
     EDBCommandBuilder cb = new EDBCommandBuilder();
     cb.DataAdapter = adap;
     cb.GetUpdateCommand();

It looks like the EDBCommandBuilder constructor which accepts a DataAdapter
is not initializing the DataAdapter correctly.

Regards,

Hedley

Hedley,

<< ... an InvalidOperationException is thrown which says "SelectCommand
property needs to be initialized." >>

I'll check it out.

--
Tim Young
Elevate Software
www.elevatesoft.com