xpath??

[luke]

Hi,
I am very new to xml. I have a datatable I need to group by and was
suggested that xml and xpath might be the way to go. I converted the
datatable to xml but don't know what to do next. Can anyone point me
to the right direction. This is what I am trying to do:
- have datatable (~300k rows and 5 cols)
- need to group by column1(string catagory) and column2(date)
- display the totals by column1 and column2 in datagrid.

Any help is appreciated.

Thanks.

[Dimitre Novatchev]

The advice to convert the database to XML was clearly a bad joke. RDBMSes
are best at what they can do best -- work with relational data.

Apart from this, if you cannot reverse your decision and go back, get a good
book on XPath/XSLT like e.g.:

"Beginning XSLT" by Jeni Tennison.

Then read about grouping methods in XSLT -- e.g.:

http://jenitennison.com/xslt/grouping/index.xml
or
http://www.topxml.com/code/default.a...20010129150851
Dimitre Novatchev.
FXSL developer, XML Insider,

http://fxsl.sourceforge.net/ -- the home of FXSL
Resume: http://fxsl.sf.net/DNovatchev/Resume/Res.html

"luke" <lu*****@yahoo.com> wrote in message
news:87**************************@posting.google.c om...

Hi,
I am very new to xml. I have a datatable I need to group by and was
suggested that xml and xpath might be the way to go. I converted the
datatable to xml but don't know what to do next. Can anyone point me
to the right direction. This is what I am trying to do:
- have datatable (~300k rows and 5 cols)
- need to group by column1(string catagory) and column2(date)
- display the totals by column1 and column2 in datagrid.

Any help is appreciated.

Thanks.

[Kathleen Dollard]

Luke,

I agree with Dimitre, but wanted to clarify. You can't do this in an ADO.NET
datatable in any practical manner. Moving 300,000 rows to your applcation
server or client to perform a summation is a bad idea. This is a job for a
stored procedure or query against your database. Check out the Pivot
options.

--
Kathleen Dollard
Microsoft MVP
Author "Code Generation in Microsoft .NET"
"luke" <lu*****@yahoo.com> wrote in message
news:87**************************@posting.google.c om...

Hi,
I am very new to xml. I have a datatable I need to group by and was
suggested that xml and xpath might be the way to go. I converted the
datatable to xml but don't know what to do next. Can anyone point me
to the right direction. This is what I am trying to do:
- have datatable (~300k rows and 5 cols)
- need to group by column1(string catagory) and column2(date)
- display the totals by column1 and column2 in datagrid.

Any help is appreciated.

Thanks.