Re: Setting Up XML DB
From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/05/04
- Next message: William Ryan eMVP: "Re: DataGrid control question"
- Previous message: James P: "Re: Sorting"
- In reply to: Wayne Wengert: "Re: Setting Up XML DB"
- Next in thread: Wayne Wengert: "Re: Setting Up XML DB"
- Reply: Wayne Wengert: "Re: Setting Up XML DB"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 May 2004 18:40:23 -0400
myDataSet.ReadXML(@"Path:\File.xml");
THis may aslo be helpful
http://www.knowdotnet.com/articles/datarelation.html
"Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
news:OAxXh8uMEHA.740@TK2MSFTNGP12.phx.gbl...
> Thanks for the continued education.
>
> When you say you loaded my XML into a dataset, exactly how did you do
that?
>
> As for the tables, there is no link - I can easily give each show data
entry
> an identity value ("ShowID") and then use that as a link in the entries
> table.
>
> Wayne
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:O0CPL9tMEHA.1312@TK2MSFTNGP12.phx.gbl...
> > I just loaded your xml into a dataset and got two tables as expected.
In
> > your dataset or object, you need a link between the two, there doesn't
> > appear to be one. If one value is common in both tables, then you can
use
> a
> > DataRelation and the rest is really easy, I can walk you through it in a
> few
> > minutes. However, do I understand the structure correctly in that there
is
> > some sort of relationship between the two, some link between the two
> > tables.?
> > "Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
> > news:#wnss#rMEHA.3012@tk2msftngp13.phx.gbl...
> > > Thanks for the help here. I know I am confused on procedures and terms
> for
> > > all this. Basically, I want to end up with an XML file similar to the
> one
> > > shown below. I currently have 2 arrays - one with just the common show
> > data
> > > (showname and showdate) and another array with sets of values for each
> > entry
> > > (name, team, event, time).
> > >
> > > From what I've read I believe I want to create a new datatable for
each
> of
> > > those 2 current arrays and define columns as appropriate? But since
the
> > > contest data table will have just one row and the entries table will
> have
> > > many rows I don't see how to build an object from which I can export
the
> > XML
> > > I need. I've though of a cross join (right term?) where the output
will
> > > consist of rows where the contest data is repeated in each row. That
> seems
> > > inefficient?
> > >
> > > Any pointers are much appreciated
> > >
> > > ================================================
> > >
> > > <contest>
> > > <contestinfo>
> > > <contestname>South Side Contest</contestname>
> > > <contestdate>2004-05-07</contestdate>
> > > </contestinfo>
> > > <entry>
> > > <name>Johnny Jones</name>
> > > <team>Marauders</team>
> > > <event>Relay Race</event>
> > > <time>10:30 AM</time>
> > > </entry>
> > > <entry>
> > > <name>Mary Smith</name>
> > > <team>Marauders</team>
> > > <event>Relay Race</event>
> > > <time>10:30 AM</time>
> > > </entry>
> > > <entry>
> > > <name>Ed Brown</name>
> > > <team>Hot Shots</team>
> > > <event>200 Yd</event>
> > > <time>10:45 AM</time>
> > > </entry>
> > > <entry>
> > > <name>Jack Green</name>
> > > <team>Marauders</team>
> > > <event>200 Yd</event>
> > > <time>10:45 AM</time>
> > > </entry>
> > > </contest>
> > > =============================================
> > >
> > > Wayne
> > >
> > > "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> > > news:ehM7$4qMEHA.936@TK2MSFTNGP11.phx.gbl...
> > > > Hi Wayne:
> > > >
> > > > What part do you need? I'll try to find something in particular.
> > > >
> > > > if you have a datatab;le, the rest is easy:
> > > >
> > > > DataSet ds = new DataSet();
> > > > ds.Tables.Add(DataTableYouCretaed);
> > > > ds.WriteXML(@"Path:\Fielname.xml");
> > > >
> > > > then, set up a dataadapter and just call update
> > > > dataAdapter1.Update(ds.Tables[0]) //you may need multiple adapters
> > > depending
> > > > on how many tables you have.
> > > >
> > > > HTH,
> > > >
> > > > Bill
> > > > "Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
> > > > news:uplJDxqMEHA.2780@TK2MSFTNGP09.phx.gbl...
> > > > > William;
> > > > >
> > > > > Thanks for the reply. Do you have a pointer to information or
> examples
> > > of
> > > > > how to accomplish this? I am feeling like it is a catch 22 since
the
> > > only
> > > > > way I see to get a datatable is to have a dataset to contain it
but
> I
> > > have
> > > > > not yet created the dataset. I am unsure of how to accomplish
this.
> > > > >
> > > > > Wayne
> > > > >
> > > > > "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in
message
> > > > > news:%23UdeCkqMEHA.2500@TK2MSFTNGP12.phx.gbl...
> > > > > > One easy way is to load the data into a datatable instead of
> arrays,
> > > or
> > > > > use
> > > > > > the arrays to load a datatable. Put the datatable in a dataset
> and
> > > use
> > > > > the
> > > > > > .WriteXML method to write it and DataSet.ReadXML to read it.
> > > > > >
> > > > > > You can also make your Arrays memebers of a class and mark the
> class
> > > as
> > > > > > Serializable and use the serialization libraries to accomplish
> this.
> > > > > >
> > > > > > HTH,
> > > > > >
> > > > > > Bill
> > > > > > "Wayne Wengert" <wayneDONTWANTSPAM@wengert.com> wrote in message
> > > > > > news:OVwI50pMEHA.1556@TK2MSFTNGP10.phx.gbl...
> > > > > > > I am trying to build a VB.NET Windows application in which I
> want
> > to
> > > > > > create
> > > > > > > an XML file from data collected from the user and stored in
> > arrays.
> > > I
> > > > am
> > > > > > > looking for any pointers to information on how to accomplish
> this.
> > > > > > >
> > > > > > > TIA
> > > > > > >
> > > > > > > Wayne
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: William Ryan eMVP: "Re: DataGrid control question"
- Previous message: James P: "Re: Sorting"
- In reply to: Wayne Wengert: "Re: Setting Up XML DB"
- Next in thread: Wayne Wengert: "Re: Setting Up XML DB"
- Reply: Wayne Wengert: "Re: Setting Up XML DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
