Need help designing XML Dataset

[Tony Girgenti]

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\)]

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.comwrote in message
news:uP**************@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]

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)" <No************@comcast.netNoSpamMwrote in
message news:Os**************@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.comwrote in message
news:uP**************@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

[Max Schneider, Image Innovation]

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.comwrote in message
news:u9**************@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)" <No************@comcast.netNoSpamMwrote in
message news:Os**************@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.comwrote in message
news:uP**************@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]

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" <ma*@imageinnova-takethisout.comwrote in
message news:z3*************@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.comwrote in message
news:u9**************@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)" <No************@comcast.netNoSpamMwrote in
message news:Os**************@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.comwrote in message
news:uP**************@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

[smadden]

I agree. Why not just add attribute state, and then enumerate the
value for each of the 50 states.
Max Schneider, Image Innovation wrote:

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.comwrote in message
news:u9**************@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)" <No************@comcast.netNoSpamMwrote in
message news:Os**************@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.comwrote in message
news:uP**************@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

[Daniel Brittain Dugger]

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