App.config string <> strongly typed ds

6 Feb 2006 10:49 AM

Nickl

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

10 Feb 2006 4:56 PM

Mateus Padovani Velloso

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.

Show quote

"Nickl" <Ni***@discussions.microsoft.com> wrote in message
news:33168B53-7CB7-49F1-BAAF-D1EAA48E6B1E@microsoft.com...
>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

22 Feb 2006 10:16 AM

Nickl

Thanks Mateus,
That has worked perfectly. I now generate all my datasets manually, and I
enjoy the control.
Cheers

Show quote

"Mateus Padovani Velloso" wrote:

> 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.
>
> "Nickl" <Ni***@discussions.microsoft.com> wrote in message
> news:33168B53-7CB7-49F1-BAAF-D1EAA48E6B1E@microsoft.com...
> >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
>
>
>