Solved

Filtering an XML file by product name, displaying results in a datalist

Posted on 2013-12-01
2
225 Views
Last Modified: 2013-12-04
I am working in ASP.Net (vb) with a client's XML file (reduced from 319 entries to 3):

 
<?xml version= "1.0"?>
<products>
	<product id="001">
		<division>Division1</division>
		<name>AName</name>
		<model>Model1</model>
		<category></category>
		<datathumbURL>image.jpg</datathumbURL>
		<datasheetURL>document.pdf</datasheetURL>
		<thumbURL>image.png</thumbURL>
		<fullImageURL></fullImageURL>
		<description>Many, many words here</description>
		<contactSnail>address, city, state, zip</contactSnail>
		<contactDigits>phone</contactDigits>
		<contactWebsite>URL</contactWebsite>
	</product>
	<product id="002">
		<division>Division2</division>
		<name>BName</name>
		<model>Model2</model>
		<category></category>
		<datathumbURL>image.jpg</datathumbURL>
		<datasheetURL>document.pdf</datasheetURL>
		<thumbURL>image.png</thumbURL>
		<fullImageURL></fullImageURL>
		<description>many, many words here</description>
		<contactSnail>address, city, state, zip</contactSnail>
		<contactDigits>phone</contactDigits>
		<contactWebsite>URL</contactWebsite>
	</product>
	<product id="003">
		<division>Division3</division>
		<name>CName</name>
		<model>Model3</model>
		<category></category>
		<datathumbURL>image.jpg</datathumbURL>
		<datasheetURL>document.pdf</datasheetURL>
		<thumbURL>image.png</thumbURL>
		<fullImageURL></fullImageURL>
		<description>man, many words here</description>
		<contactSnail>address, city, state, zip</contactSnail>
		<contactDigits>phone</contactDigits>
		<contactWebsite>URL</contactWebsite>
	</product>
</products>

Open in new window


... and have created the sort and display code which works as expected (sorting the list of 319 products by name, division or model):

<script runat="server">
	Sub Page_Load

		dim dsProducts = New DataSet
		dsProducts.ReadXml(MapPath("products.xml"))
		
		Dim sid As String
		sid = Request.QueryString("sid")	
			
		If String.IsNullOrEmpty(Request.QueryString("sid")) Then
			dsProducts.Tables(0).DefaultView.Sort = "name, division, model ASC"			
		Elseif sid = "div" Then
			dsProducts.Tables(0).DefaultView.Sort = "division, name, model ASC"
		Elseif sid = "mod" Then
			dsProducts.Tables(0).DefaultView.Sort = "model, name, division ASC"	
		End If
	
		Dim dsProductsSort = dsProducts.Tables(0).DefaultView.ToTable()
		dlProducts.DataSource = dsProductsSort
		dlProducts.DataBind()
	End sub
</script>

<asp:DataList id="dlProducts" runat="server">
	<ItemTemplate>
		<a href="products-details.aspx?id=<%#Container.DataItem("id")%>" style="color:blue"> <%#Container.DataItem("name")%> | <%#Container.DataItem("model")%></a> | <%#Container.DataItem("division")%> 
	</ItemTemplate>
</asp:DataList>

Open in new window


The client would now like a page that will allow clicking on a letter of the alphabet (A - B - C, etc...) to see a list of product names beginning with that letter.  In the example XML code these are listed as AName, BName and CName.

Ideally, the results would be shown in the same datalist included above.

Easy enough to do using a database - I can't seem to wrap my ahead around making it work using an XML file as the datasource.  Shuffling fields in the XML file is an option if required.

Help?
0
Comment
Question by:henryroark
2 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39689492
You should be able to add a RowFilter to the view based on the letter selected:
Dim filterLetter As String = "A"

...

If String.IsNullOrEmpty(Request.QueryString("sid")) Then
    dsProducts.Tables(0).DefaultView.Sort = "name, division, model ASC"
    dsProducts.Tables(0).DefaultView.RowFilter = "name like '" & filterLetter & "%'"
    ...
End If

Open in new window

0
 

Author Closing Comment

by:henryroark
ID: 39696268
Simple and perfect, thank you.  I had it in mind that it would be a complicated matter.  Knowing about .RowFilter opens up a lot of possibilities.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now