DatatAdapter ADO.Net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

DataAdapter configuration wizard not accepting my 130 column Access table
which previously contained 30 columns for a local application. Used Query
Builder to "check" additional DB columns. Wizard Error states "Select"
statement can't be created. Is there a limit to the no of columns the DA
will accept?

Comments?

Steve
 
Hi,

No AFAIK, what if you do it all from code, not using the wizard.

BTW, 130 are a LOT of columns :)

cheers,
 
Ya, I Know. I'm trying to force something that might not work and only serve
to bite me later. I want the safeguards of the wizard to work if possible.
I'll add to code if I have too

I'm currently considering redesigning the database. Please see thrid thead of
http://www.microsoft.com/communitie...622da0-1e0b-40b2-a20b-4809eebcd205&sloc=en-us

My question to you is can I use Query Builder to build a complex (large)
query for the DA to accept. Should I add only tables query builder? Are
Views safe to use? Performance? Should I bring things together in the
database first or in Query Builder. General Comments if you were me?

Steve
 
Hi,


To be honest with you I have never, ever use te Query builder, call me
oldie, but I prefer to write the query myself. I do so in the query
analyzer, when I know it's correct then I move it to its final destination,
be it a SP or a query in the code.

What to do depends of your case, if you have no use for the tables except
getting the result of the query then do not pull the tables, just call the
query, it's more efficient do it in the DB than in the program.


cheers,
 
Back
Top