You must Sign In to post a response.
  • Category: XML

    How to display xml file using dataset

    Hi

    this 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
  • #769679
    it seems you are filtering with help of dataview and no where you are using that to binding into gridview instead you used dataset.

    Try once below

    DataSet ds1 = new DataSet();
    ds1.ReadXml(Server.MapPath("~/Highlightsreport/Highlightsreport.xml"));
    DataView dv = new DataView(ds.Tables["highlightsreport/Highlightstext"], "regionname='MMT'", "Highlightstext ", DataViewRowState.CurrentRows);
    GridView1.DataSource = dv;
    GridView1.DataBind()

    Thanks!
    B.Ramana Reddy


  • Sign In to post your comments