XML query and databinding

[raheel]

Hi!
I want to be able to query an XML data. For example I
have an employee xml file which lists the detail of the
employees using XML markup. I want to be able to query
this data so that I get the employees with salary > some
amount. How can I do this?
I am later going to bind the query results to a DataList.
Thanks!

 

[Craig Deelsnyder]

Hi!
I want to be able to query an XML data. For example I
have an employee xml file which lists the detail of the
employees using XML markup. I want to be able to query
this data so that I get the employees with salary > some
amount. How can I do this?
I am later going to bind the query results to a DataList.
Thanks!

Well, assuming the XML is 'good', you can import the XML into a DataSet
(using its ReadXxml method), which will create tables for each level of
nodes, etc. See this article on consuming RSS for an example:

http://aspnet.4guysfromrolla.com/articles/031903-1.aspx

 

[Kirk Allen Evans [MVP]]

Another means is to take advantage of the XmlNodeList implementing the
IEnumerable interface, enabling it to be a datasource for binding within
ASP.NET. Not as easy as DataSets, but not all XML can fit within a DataSet.

http://weblogs.asp.net/kaevans/posts/9713.aspx