Sorting an XML file

[Leszek]

Hello,

I need to sort an XML file and then display the result in a drop-down list
on an ASP.NET WebForm.
What should I use? DataSet, DataReader, something else? Right now I have the
following code:

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("categories.xml"), XmlReadMode.InferSchema);
cboType.DataSource = ds;
cboType.DataBind();

Thanks for any help,
Leszek Taratuta

 

[Miha Markic]

Hi Leszek,

Use DataView:
DataView dv = new DataView(ds.Tables[0], string.Empty, "Column1 ASC",
DataViewRowState.CurrentRows);
// this sorts by column1 ascending - you might add other columns, too.
// then just bind the dataview instead of dataset (adjust DataMember too).
cboType.DataSource = dv;

 

[Leszek]

Thanks a lot. It works fine.

I'm just wondering if there would be any other method to sort XML files
without using DataSets and DataViews. Would it be possible to use XSLT?

Thanks,
Leszek Taratuta

Hi Leszek,

Use DataView:
DataView dv = new DataView(ds.Tables[0], string.Empty, "Column1 ASC",
DataViewRowState.CurrentRows);
// this sorts by column1 ascending - you might add other columns, too.
// then just bind the dataview instead of dataset (adjust DataMember too).
cboType.DataSource = dv;

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

Hello,

I need to sort an XML file and then display the result in a drop-down list
on an ASP.NET WebForm.
What should I use? DataSet, DataReader, something else? Right now I have the
following code:

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("categories.xml"), XmlReadMode.InferSchema);
cboType.DataSource = ds;
cboType.DataBind();

Thanks for any help,
Leszek Taratuta

 

[Miha Markic]

Hi Leszek,

Thanks a lot. It works fine.

Fine

I'm just wondering if there would be any other method to sort XML files
without using DataSets and DataViews. Would it be possible to use XSLT?

You might read the following article:
http://www.topxml.com/code/default.asp?p=3&id=v20020313192843