Microsoft XML - Need help designing XML Dataset

Author

Need help designing XML Dataset

Tony Girgenti

2006-09-24, 6:51 pm

Hello

I developed and tested a web application using VS.NET 2003, VB, .NET
Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. It uses a web form.

I tried doing this without any help, but i'm getting nowhere.

I want to create an XML schema (XSD) for a dataset/datatable using the XML
designer.

I want to be able to have a table for each trip. The trip will contain a
trip no, date etc. But i also want it to have a State element like "PA, NJ,
MD" for each state with miles traveled for each state. I don't want to
enter 50 elements name MilesPA, MilesNJ, MilesMD etc.

Is there a way to define an array of states for the trip table without doing
each state individually ? How would i reference the table/array in code ?

Any help would be gratefully appreciated.

Thanks,
Tony

Cowboy $Gregory A. Beamer$

2006-09-24, 6:51 pm

Create a table with the states in it. Add a reference in your other table.
Add both tables to the same dataset. Add a relationship between the tables
in the DataSet. You can now refer to the parent (state) records from the
other table.

If you then want to query a single state, you can filter on the records that
are linked to the state in question.

Hope this helps.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
news:uPMY9xc2GHA.1256@TK2MSFTNGP04.phx.gbl...
> Hello
>
> I developed and tested a web application using VS.NET 2003, VB, .NET
> Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. It uses a web form.
>
> I tried doing this without any help, but i'm getting nowhere.
>
> I want to create an XML schema (XSD) for a dataset/datatable using the XML
> designer.
>
> I want to be able to have a table for each trip. The trip will contain a
> trip no, date etc. But i also want it to have a State element like "PA,
> NJ, MD" for each state with miles traveled for each state. I don't want
> to enter 50 elements name MilesPA, MilesNJ, MilesMD etc.
>
> Is there a way to define an array of states for the trip table without
> doing each state individually ? How would i reference the table/array in
> code ?
>
> Any help would be gratefully appreciated.
>
> Thanks,
> Tony
>

Tony Girgenti

2006-09-24, 6:51 pm

Hello Cowboy.

Thanks for your help with this.

I don't see how what you are saying help's me. Here is what i have:
Trip DataTable
Tripno
Tractorno
Location
Date
Mileage in state (can occur as many as 50 times, one for each state or
can be just 1 state)
Fuel in state (can occur as many as 50 times, one for each state or can
be just 1 state)
Tolls

So, instead of adding fifty elements state(twice, 1 for mileage and 1 for
fuel), i want to just say it once and use some kind of index to loop thru
the states for each trip.

There will always be at least 1 state for each trip.

I hope that makes sense. I don't know how to do that with the XML designer.
I also don't know how to put it in code to access the individual columns for
each trip.

Thanks
Tony

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:OsesNje2GHA.4808@TK2MSFTNGP02.phx.gbl...
> Create a table with the states in it. Add a reference in your other table.
> Add both tables to the same dataset. Add a relationship between the tables
> in the DataSet. You can now refer to the parent (state) records from the
> other table.
>
> If you then want to query a single state, you can filter on the records
> that are linked to the state in question.
>
> Hope this helps.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> *************************************************
> Think outside of the box!
> *************************************************
> "Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
> news:uPMY9xc2GHA.1256@TK2MSFTNGP04.phx.gbl...
>
>

Max Schneider, Image Innovation

2006-09-24, 6:51 pm

What about adding an element that occurs from 1..n that has an attribute of
the state code? A sample XML would be:

<Trip>
<Miles state="OH">75</Miles>
<Miles state="KY">300</Miles>
<Miles state="TN">100</Miles>
</Trip>

Regards,

Max

"Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
news:u9XZwSf2GHA.4756@TK2MSFTNGP04.phx.gbl...
> Hello Cowboy.
>
> Thanks for your help with this.
>
> I don't see how what you are saying help's me. Here is what i have:
> Trip DataTable
> Tripno
> Tractorno
> Location
> Date
> Mileage in state (can occur as many as 50 times, one for each state or
> can be just 1 state)
> Fuel in state (can occur as many as 50 times, one for each state or can
> be just 1 state)
> Tolls
>
> So, instead of adding fifty elements state(twice, 1 for mileage and 1 for
> fuel), i want to just say it once and use some kind of index to loop thru
> the states for each trip.
>
> There will always be at least 1 state for each trip.
>
> I hope that makes sense. I don't know how to do that with the xml
> designer. I also don't know how to put it in code to access the individual
> columns for each trip.
>
> Thanks
> Tony
>
> "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
> message news:OsesNje2GHA.4808@TK2MSFTNGP02.phx.gbl...
>
>

Tony Girgenti

2006-09-24, 6:51 pm

Hello Max.

It looks like you are creating XML data. I'm looking for how to define the
data with a schema.

Thanks,
Tony

"Max Schneider, Image Innovation" <max@imageinnova-takethisout.com> wrote in
message news:z34Pg.33$eD1.12@newsfe06.lga...
> What about adding an element that occurs from 1..n that has an attribute
> of the state code? A sample XML would be:
>
> <Trip>
> <Miles state="OH">75</Miles>
> <Miles state="KY">300</Miles>
> <Miles state="TN">100</Miles>
> </Trip>
>
>
> Regards,
>
> Max
>
> "Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
> news:u9XZwSf2GHA.4756@TK2MSFTNGP04.phx.gbl...
>
>

smadden

2006-09-24, 6:51 pm

I agree. Why not just add attribute state, and then enumerate the
value for each of the 50 states.

Max Schneider, Image Innovation wrote:[color=darkred]
> What about adding an element that occurs from 1..n that has an attribute of
> the state code? A sample XML would be:
>
> <Trip>
> <Miles state="OH">75</Miles>
> <Miles state="KY">300</Miles>
> <Miles state="TN">100</Miles>
> </Trip>
>
>
> Regards,
>
> Max
>
> "Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message
> news:u9XZwSf2GHA.4756@TK2MSFTNGP04.phx.gbl...

Daniel Brittain Dugger

2006-09-24, 6:52 pm

Tony:

I am not familiar with VS 2003. I started with .net 2.0 and VS 2005. The way
that I would handle this situation is as follows:

I would create two data tables:

1. TblTrips
2. TblTripDetails

TblTrips would have the following fields:

ID
TripNo
TractorNo

TblTripDetails would have the following fields:
ID
TripNo
Location
Date
MilesIn
FuelIn
Tolls

I am assuming that location is the state. If it is not, just replace
Location with state and insert State into TblTrips.

You can then establish a relationship in the designer. In code you can
create a datarow collection (array) and access all of the children based on
the trip id.

Hope this helps,

Daniel Brittain Dugger

TblTripDetails would have the following
"Tony Girgenti" wrote:

> Hello
>
> I developed and tested a web application using VS.NET 2003, VB, .NET
> Framework 1.1.4322, ASP.NET 1.1.4322 and IIS5.1. It uses a web form.
>
> I tried doing this without any help, but i'm getting nowhere.
>
> I want to create an XML schema (XSD) for a dataset/datatable using the XML
> designer.
>
> I want to be able to have a table for each trip. The trip will contain a
> trip no, date etc. But i also want it to have a State element like "PA, NJ,
> MD" for each state with miles traveled for each state. I don't want to
> enter 50 elements name MilesPA, MilesNJ, MilesMD etc.
>
> Is there a way to define an array of states for the trip table without doing
> each state individually ? How would i reference the table/array in code ?
>
> Any help would be gratefully appreciated.
>
> Thanks,
> Tony
>
>
>