Is oledbcommandbuilder viable?

[John]

Hi

In vs2008 I need to use data adapter with table of large number of fields.

1. Can I get one of the wizards to auto generate initial SELECT command? If
not, is there another way to auto generate?

2. For UPDATE, DELETE, INSERT is it viable to use oledbcommandbuilder to
avoid manual coding? If not, is there another alternative to auto generate
these commands?

Sorry, I am not being lazy but there are just too many fields and table
structure changes over time and often client requires short turn around
times.

Many Thanks

Regards

 

[Scott M.]

The CommandBuilder will not help you when you have complex commands to be
generated. If you are looking for something a bit more user friendly, you
can use the TableAdapter Configuration Wizard to take you through the
process.

http://www.google.com/search?q=how+...-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1


-Scott

 

[Cor Ligthert[MVP]]

John,

Yes it is variable as you put your latest select string in the command of
the dataadapter and do oledbdataadapter.fillschema

Like Scott says, the commandbuilder is only usable in simple select strings

Cor