How to display xml file using dataset
Hithis is my xml file
<?xml version="1.0" encoding="utf-8" ?>
<Highlight>
<highlightsreport>
<s_no>504</s_no>
<Highlightstext>
AAAAAAAA
</Highlightstext>
<regionname>XYZ</regionname>
</highlightsreport>
<highlightsreport>
<s_no>557</s_no>
<Highlightstext>
BBBB
</Highlightstext>
<regionname>MMT</regionname>
</highlightsreport>
<highlightsreport>
<s_no>508</s_no>
<Highlightstext>KKKKK</Highlightstext>
<regionname>ARUNACHAL PRADESH</regionname>
</highlightsreport>
</Highlight
my requirement is to display Highlightstext of regionname='MMT' in gridview
following is my code
DataSet ds1 = new DataSet();
ds1.ReadXml(Server.MapPath("~/Highlightsreport/Highlightsreport.xml"));
DataView dv = new DataView(ds1.Tables["highlightsreport/Highlightstext"]);
dv.RowFilter = "regionname='MMT'";
GridView1.DataSource = ds1;
GridView1.DataBind()
there is no error showing .but problem is it is not filtering xml file .
complete file is displaying .
I need only the Highlightstext of regionname='MMT'
how to solve this
Regards
Baiju