How to search by date in an xml file and display it on a datagrid in vb.net.

[Avatar Viper]

I have an xml file:

<?xml version="1.0"?>
<ProductList>
<Products>
<SKU>1</SKU>
<Price>100.00</Price>
<Description>Widget #1</Description>
<pubDate>8/6/2004</pubDate>
</Products>
<Products>
<SKU>2</SKU>
<Price>10.00</Price>
<Description>Widget #2</Description>
<pubDate>8/6/2004</pubDate>
</Products>
<Products>
<SKU>3</SKU>
<Price>30.00</Price>
<Description>Widget #3</Description>
<pubDate>8/5/2004</pubDate>
</Products>
</ProductList>

Assume today date is 8/6/2004.

I have tried RowFilter = "pubDate = ‘"+Date.Today+"'"
and the Find method in DataView and then display it in on a datagrid
but to no avail why???

[Greg Hurlman]

Date.Today is going to return "8/6/2004 12:00:00 AM".
Date.Today.ToShortDateString should return "8/6/2004"; try that.

---
Greg Hurlman
ghurlman*AT*squaretwo*DOT*net
http://blogs.squaretwo.net

"Avatar Viper" wrote:

I have an xml file:

<?xml version="1.0"?>
<ProductList>
<Products>
<SKU>1</SKU>
<Price>100.00</Price>
<Description>Widget #1</Description>
<pubDate>8/6/2004</pubDate>
</Products>
<Products>
<SKU>2</SKU>
<Price>10.00</Price>
<Description>Widget #2</Description>
<pubDate>8/6/2004</pubDate>
</Products>
<Products>
<SKU>3</SKU>
<Price>30.00</Price>
<Description>Widget #3</Description>
<pubDate>8/5/2004</pubDate>
</Products>
</ProductList>

Assume today date is 8/6/2004.

I have tried RowFilter = "pubDate = ‘"+Date.Today+"'"
and the Find method in DataView and then display it in on a datagrid
but to no avail why???