Best way to Sort an XmlDocument for display in a datagrid

[bep]

Hello

What is the best way to sort an XmlDocument for display in a DataGrig?

I can use Xpath with an XpathExpression , and a XpathNavigator. But this
XpathNavigator object is of no use to me, I need a XmlDocument. So is there
an easy way to convert an XPathNavigator object to an XmlDocument?

And I could use a piece of Xstl to transform the doc. But this seems like a
lot of work. I would have to load the Xslt from file, cache it, and apply it.
I also have not found an easy way to transform an XmlDocument in memory. It
seems it is all aimed at taking a disk file, and applying the XSLT from a
file,a nf write to a file.

Thanks for any help.
David

[Hermit Dave]

for sorting you dont need to use XPathExpression .. its normally used to do a
scan and get nordes that match a certain criteria.
if you want to sort it.
Create a Dataset
Use XmlDataDocument (with relation to the dataset).
Load the XML Document or a part of it (if so load the schema first)
At this step the dataset is populated with the xml data.
now you can apply dataset.tables[0].Select(sortcri teria) to fetch the sorted
order of datarows that can be imported into a table clone and can be
displayed in the datagrid

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"be*@10.10.10.1 0" <be*@10.10.10.1 0@discussions.m icrosoft.com> wrote in
message news:C7******** *************** ***********@mic rosoft.com...

Hello

What is the best way to sort an XmlDocument for display in a DataGrig?

I can use Xpath with an XpathExpression , and a XpathNavigator. But this
XpathNavigator object is of no use to me, I need a XmlDocument. So is there an easy way to convert an XPathNavigator object to an XmlDocument?

And I could use a piece of Xstl to transform the doc. But this seems like a lot of work. I would have to load the Xslt from file, cache it, and apply it. I also have not found an easy way to transform an XmlDocument in memory. It seems it is all aimed at taking a disk file, and applying the XSLT from a
file,a nf write to a file.

Thanks for any help.
David

[bep]

Thanks for your help

How do I get the XmlDataDocument into the Dataset?

Will this work without a schema? We get this data from another system, and
there is no Schema, I would have to create one.

This is also a lot of processing and memory usage. I am surprised XML
sorting is so hard to do...

Thanks again

"Hermit Dave" wrote:

for sorting you dont need to use XPathExpression .. its normally used to do a
scan and get nordes that match a certain criteria.
if you want to sort it.
Create a Dataset
Use XmlDataDocument (with relation to the dataset).
Load the XML Document or a part of it (if so load the schema first)
At this step the dataset is populated with the xml data.
now you can apply dataset.tables[0].Select(sortcri teria) to fetch the sorted
order of datarows that can be imported into a table clone and can be
displayed in the datagrid

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"be*@10.10.10.1 0" <be*@10.10.10.1 0@discussions.m icrosoft.com> wrote in
message news:C7******** *************** ***********@mic rosoft.com...

Hello

What is the best way to sort an XmlDocument for display in a DataGrig?

I can use Xpath with an XpathExpression , and a XpathNavigator. But this
XpathNavigator object is of no use to me, I need a XmlDocument. So is

there

an easy way to convert an XPathNavigator object to an XmlDocument?

And I could use a piece of Xstl to transform the doc. But this seems like

a

lot of work. I would have to load the Xslt from file, cache it, and apply

it.

I also have not found an easy way to transform an XmlDocument in memory.

It

seems it is all aimed at taking a disk file, and applying the XSLT from a
file,a nf write to a file.

Thanks for any help.
David

[Hermit Dave]

i have just replied to another user with a complete example using xml, xsd
(for more info refer to post - Urgent help needed converting xmlnode to
dataset)

DataSet ds = new DataSet();
ds.ReadXmlSchem a(@"..\..\Custo mers.xsd");

// create matching xml data document
XmlDataDocument xdd = new XmlDataDocument (ds);
try
{
xdd.Load(@"..\. .\Customers.xml ");
}
catch(Exception ex)
{
MessageBox.Show (ex.Message, "Error Loading XML");
}
this.dgXML.Data Source = ds;
this.dgXML.Data Member = "CustomerDa ta";

hope this helps

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"be*@10.10.10.1 0" <be*********@di scussions.micro soft.com> wrote in message
news:90******** *************** ***********@mic rosoft.com...

Thanks for your help

How do I get the XmlDataDocument into the Dataset?

Will this work without a schema? We get this data from another system, and
there is no Schema, I would have to create one.

This is also a lot of processing and memory usage. I am surprised XML
sorting is so hard to do...

Thanks again

"Hermit Dave" wrote:

for sorting you dont need to use XPathExpression .. its normally used to do a scan and get nordes that match a certain criteria.
if you want to sort it.
Create a Dataset
Use XmlDataDocument (with relation to the dataset).
Load the XML Document or a part of it (if so load the schema first)
At this step the dataset is populated with the xml data.
now you can apply dataset.tables[0].Select(sortcri teria) to fetch the sorted order of datarows that can be imported into a table clone and can be
displayed in the datagrid

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"be*@10.10.10.1 0" <be*@10.10.10.1 0@discussions.m icrosoft.com> wrote in
message news:C7******** *************** ***********@mic rosoft.com...

Hello

What is the best way to sort an XmlDocument for display in a DataGrig?

I can use Xpath with an XpathExpression , and a XpathNavigator. But this XpathNavigator object is of no use to me, I need a XmlDocument. So is

there

an easy way to convert an XPathNavigator object to an XmlDocument?

And I could use a piece of Xstl to transform the doc. But this seems like

a

lot of work. I would have to load the Xslt from file, cache it, and

apply it.

I also have not found an easy way to transform an XmlDocument in

memory. It

seems it is all aimed at taking a disk file, and applying the XSLT

from a file,a nf write to a file.

Thanks for any help.
David

[David Browne]

"be*@10.10.10.1 0" <be*********@di scussions.micro soft.com> wrote in message
news:90******** *************** ***********@mic rosoft.com...

Thanks for your help

How do I get the XmlDataDocument into the Dataset?

Will this work without a schema? We get this data from another system, and
there is no Schema, I would have to create one.
DataSet.InferXM LSchema or just use the Schema designer in Visual Studio.

This is also a lot of processing and memory usage. I am surprised XML
sorting is so hard to do...

Not noticably more than applying a XLST transform.
David