How to Store Multidimensional DataSet (.NET 1.1)

Hi,

I want to read a bunch of related tables into a DataSet, update some data in
some of the tables and save the changes back to the database. How can this
be done? Can someone please point me to a corresponding tutorial? I've been
searching through MSDN but couldn't find anything appropriate. When I use
the SqlDataAdapter to read more than one query, all the tables get names
different from the query source table name. How is it supposed to store it's
data back into the database then? And how can I have DataRelation objects
automatically created from my query? (E.g.: "SELECT * FROM Order; SELECT *
FROM OrderItem; SELECT * FROM Address")

Thanks for enlightening me!

Axel Dahmen

Scott
Sat Aug 27 22:28:58 CDT 2005

I can tell you that DataRelations are not made automatically for you under
any circumstances, you'll need to create these yourself.


"Axel Dahmen" <NO_SPAM@NoOneKnows.invalid> wrote in message
news:uc7zvy3qFHA.2540@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I want to read a bunch of related tables into a DataSet, update some data
> in
> some of the tables and save the changes back to the database. How can this
> be done? Can someone please point me to a corresponding tutorial? I've
> been
> searching through MSDN but couldn't find anything appropriate. When I use
> the SqlDataAdapter to read more than one query, all the tables get names
> different from the query source table name. How is it supposed to store
> it's
> data back into the database then? And how can I have DataRelation objects
> automatically created from my query? (E.g.: "SELECT * FROM Order; SELECT *
> FROM OrderItem; SELECT * FROM Address")
>
> Thanks for enlightening me!
>
> Axel Dahmen
>
>

ccallen
Sun Aug 28 00:09:15 CDT 2005

There's a ton of info in the .net framework sdk Quick Start:
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/RelationalData.aspx
Is a good place to start.

"Axel Dahmen" <NO_SPAM@NoOneKnows.invalid> wrote in message
news:uc7zvy3qFHA.2540@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I want to read a bunch of related tables into a DataSet, update some data
in
> some of the tables and save the changes back to the database. How can this
> be done? Can someone please point me to a corresponding tutorial? I've
been
> searching through MSDN but couldn't find anything appropriate. When I use
> the SqlDataAdapter to read more than one query, all the tables get names
> different from the query source table name. How is it supposed to store
it's
> data back into the database then? And how can I have DataRelation objects
> automatically created from my query? (E.g.: "SELECT * FROM Order; SELECT *
> FROM OrderItem; SELECT * FROM Address")
>
> Thanks for enlightening me!
>
> Axel Dahmen
>
>

Axel
Sun Aug 28 18:03:02 CDT 2005

Thanks for trying to help!

Actually the tutorial you've been pointing to doesn't contain the
information I need. I've been working with ADO.NET for several years now and
I know all the common stuff used to fill DataGrids etc.

I'm developing a framework to create an in-memory representation of my
database using typed DataSets. But I don't know if ADO.NET provides any
functionality for that. If not, I will have to create my own base class
derived from DataSet and write my own schema interpreting routines to save
the DataSet as a whole. But I want to avoid this, of course. In the end,
it's a reasonably common task.

Regards,
Axel


---------------
"ccallen" <ccallen@windowpane.com> schrieb im Newsbeitrag
news:elS4h44qFHA.3264@TK2MSFTNGP12.phx.gbl...
> There's a ton of info in the .net framework sdk Quick Start:
>
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/RelationalData.asp
x
> Is a good place to start.
>
> "Axel Dahmen" <NO_SPAM@NoOneKnows.invalid> wrote in message
> news:uc7zvy3qFHA.2540@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I want to read a bunch of related tables into a DataSet, update some
data
> in
> > some of the tables and save the changes back to the database. How can
this
> > be done? Can someone please point me to a corresponding tutorial? I've
> been
> > searching through MSDN but couldn't find anything appropriate. When I
use
> > the SqlDataAdapter to read more than one query, all the tables get names
> > different from the query source table name. How is it supposed to store
> it's
> > data back into the database then? And how can I have DataRelation
objects
> > automatically created from my query? (E.g.: "SELECT * FROM Order; SELECT
*
> > FROM OrderItem; SELECT * FROM Address")
> >
> > Thanks for enlightening me!
> >
> > Axel Dahmen
> >
> >
>
>