Is oledbcommandbuilder viable?

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top