grouping

razorback

New member
Joined
Oct 28, 2004
Messages
3
Programming Experience
1-3
Order By

I have a dataset made up of several datatables with the same schema. i was wondering if there is anyway to order these rows by multiple columns now, before i export them to xml.

DS(column names)
"client" "StartDate" "EndDate" "Status" "Priority" "Description" "Type"

I would like to be able to group the entire dataset by "Client" then by "StartDate" then by "Priority"

I am not sure how to do this other than through the sql to populate my datatables, but once i get them into my ds...they are grouped like this except within the datatable grouping. here is a small example of my sample data xml output of the dataset.

VB.NET:
 <NewDataSet>
- <Table1>
  <Client>IA - Linn</Client> 
  <StartDate>2004-10-26T00:00:00.0000000-05:00</StartDate> 
  <EndDate>2004-10-27T00:00:00.0000000-05:00</EndDate> 
  <Type>Software</Type> 
  <Status>COMPLETE</Status> 
  <Priority>0</Priority> 
  <Description>Resolved Issue</Description> 
  </Table1>
- <Table1>
  <Client>MO - Platte</Client> 
  <StartDate>2004-10-18T00:00:00.0000000-05:00</StartDate> 
  <Type>Software</Type> 
  <Status>OPEN</Status> 
  <Priority>0</Priority> 
  <Description>testing open issues</Description> 
  </Table1>
- <Table1>
  <Client>Pennsylvania SOS</Client> 
  <StartDate>2004-10-25T00:00:00.0000000-05:00</StartDate> 
  <Type>Hardware</Type> 
  <Status>OPEN</Status> 
  <Priority>0</Priority> 
  <Description>Just one more for good measure</Description> 
  </Table1>
- <Table2>
  <Client>AR - SOS</Client> 
  <StartDate>2004-10-19T00:00:00.0000000-05:00</StartDate> 
  <EndDate>2004-10-25T00:00:00.0000000-05:00</EndDate> 
  <Status>COMPLETE</Status> 
  <Priority>0</Priority> 
  <Description>worked on PA querys</Description> 
  <Status1>Complete</Status1> 
  <Type /> 
  </Table2>
- <Table2>
  <Client>IA - Linn</Client> 
  <Status>OPEN</Status> 
  <Priority>0</Priority> 
  <Description>test 2</Description> 
  <Status1>Open</Status1> 
  <Type /> 
  </Table2>
- <Table2>
  <Client>IA - Linn</Client> 
  <StartDate>2004-10-18T00:00:00.0000000-05:00</StartDate> 
  <Status>OPEN</Status> 
  <Priority>0</Priority> 
  <Description>Working on Status Report</Description> 
  <Status1>Open</Status1> 
  <Type /> 
  </Table2>
 
Last edited:
Top Bottom