If you drag a db table to a component in vs.net the DataAdapter is
automatically configured (select, delete, tablemappings, ...). Is it
possible to do this in code. I don't want to use the CommandBuilder because
the statements generated by this are not so nice. For instance the parameter
name is @P1 and not @Person_ID or @Original_Person_ID.

I would like to generate the source code for my accessors.

Kris.

The use the dataadapter config wizard (commonly known as DACW). This article
will help get you going:
http://msdn.microsoft.com/library/de...andbuilder.asp


"Kris Desmadryl" <kris.desmadrylN00SPM (AT) tenforce (DOT) com> wrote

thx for the information
Is it possible to approach this DACW in coding ?
It would be nice if I could generate all parameters for all tables in my
database by writing a small program I tried this by using the
commandbuilder, but I have some problems with it. For instance the type is
Int32 but the size is 0 and so on.

Kris

"Earl" <brikshoe (AT) newsgroups (DOT) nospam> wrote

Use the DACW to generate your parameters, then go in and tweak them. I can't
think of an easier way. Forget about the commandbuilder and life will
improve :=)

"Kris Desmadryl" <kris.desmadrylN00SPM (AT) tenforce (DOT) com> wrote

Can not wait for VS2008 and framework 3.5 to come out and be stable as it will change the way we buid data layers and connect to database.



Posted via DevelopmentNow.com Groups
http://www.developmentnow.com