App.config string <> strongly typed ds

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

Guest

I would like to use strongly typed datasets (I think), but find the following
limitation; When configuring the Dataadpter with the wizard (VS2003) a
connection object is generated for me. I want to use a connection object
based on a string in the App.Config file, but when I attempt to do this by
modifying the generated code, I lose my ability to generate a dataset.

Can I have my global connection string, and generate (typed) Dataadapters +
datasets from the toolbox, or will I have to code my own?

If I do have to code my own, can anyone give some links to some good
examples of how to do it?

I am leaning towards strong typing, but am happy to be persuaded away if
that gives me the flexibility I need.

Any help appreciated
Nick
 
Yes, you can.

Just right-click at solution explorer and choose to create a new dataset. It
will generate a XSD file, to where you can drag your tables.
Now you have your typed dataset, and can use it anywhere you want.

Using typed DataSets does not limit you of using bussines classes,
centralized connection string or anything.
 
Thanks Mateus,
That has worked perfectly. I now generate all my datasets manually, and I
enjoy the control.
Cheers
 
Back
Top