By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,092 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,092 IT Pros & Developers. It's quick & easy.

Need help designing XML Dataset

P: n/a
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
Sep 16 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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

Sep 16 '06 #2

P: n/a
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


Sep 17 '06 #3

P: n/a
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



Sep 17 '06 #4

P: n/a
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



Sep 17 '06 #5

P: n/a
Tony,

I was showing an example of what the XML structure would look like; do you
need help defining the schema, too?

BTW, I've taken out all of the cross-posts....
Regards,

Max

"Tony Girgenti" <tony(nospam)@lakesideos.comwrote in message
news:Oy***************@TK2MSFTNGP05.phx.gbl...
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
>




Sep 17 '06 #6

P: n/a
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
Sep 17 '06 #7

P: n/a
Hello Max.

Oh. I see. I should define the schema the way you have the data
structured. Then, i could have an occurence of a child for each state that
has miles/fuel using the attribute as the state.

Is that your idea ? To have a child element for each trip element ?

I'm still working on how to code the statements to work with child records
and access/update the data.

I'm sorry about the cross posts. I'm just trying to make sure my post gets
as many viewers as possible.

Thanks,
Tony

"Max Schneider, Image Innovation" <ma*@imageinnova-takethisout.comwrote in
message news:6Q***********@newsfe04.lga...
Tony,

I was showing an example of what the XML structure would look like; do you
need help defining the schema, too?

BTW, I've taken out all of the cross-posts....
Regards,

Max

"Tony Girgenti" <tony(nospam)@lakesideos.comwrote in message
news:Oy***************@TK2MSFTNGP05.phx.gbl...
>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
>>
>
>




Sep 18 '06 #8

P: n/a
Hi Tony,

Yes, that's the basic idea. I've pasted in the schema below that will
support the sample XML I'd provided previously. It will require at least one
occurrence of the child element with an unlimited upper bound. With this
structure, you can use an XQuery to retrieve specific entries
"//Trip/Miles[@state='KY']", or develop a more elaborate one to iterate on
the Trip elements and retrieve the state attribute and miles.
Hope this helps,

Max

Here's the schema for the sample XML previously posted:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
<xs:element name="Trip">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" ref="Miles"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Miles">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:integer">
<xs:attribute name="state" use="required" type="xs:NCName"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:schema>

"Tony Girgenti" <tony(nospam)@lakesideos.comwrote in message
news:ua**************@TK2MSFTNGP05.phx.gbl...
Hello Max.

Oh. I see. I should define the schema the way you have the data
structured. Then, i could have an occurence of a child for each state
that has miles/fuel using the attribute as the state.

Is that your idea ? To have a child element for each trip element ?

I'm still working on how to code the statements to work with child records
and access/update the data.

I'm sorry about the cross posts. I'm just trying to make sure my post
gets as many viewers as possible.

Thanks,
Tony

"Max Schneider, Image Innovation" <ma*@imageinnova-takethisout.comwrote
in message news:6Q***********@newsfe04.lga...
>Tony,

I was showing an example of what the XML structure would look like; do
you need help defining the schema, too?

BTW, I've taken out all of the cross-posts....
Regards,

Max

"Tony Girgenti" <tony(nospam)@lakesideos.comwrote in message
news:Oy***************@TK2MSFTNGP05.phx.gbl...
>>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.com>
wrote 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
>>>
>>
>>
>
>




Sep 19 '06 #9

P: n/a
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
Sep 24 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.