reading xml file in asp.net

Question

I have an xml file with the following structure:

< rewriteMaps>  
  < rewriteMap name="StaticRewrites" />  
  < add key="/superstar2011" value="/article.aspx?articleid=4014" />  
  < add key="/superstar2012" value="/article.aspx?articleid=4012" />  
  < add key="/superstar2012" value="/article.aspx?articleid=4012" />  
< /rewriteMaps>

I have a gridview with which I want to bind the key and values. How should I go about it? I am new to xml with gridview. Any help will be greatly appreciated.

danyolgiax · Accepted Answer · 2011-06-09 22:51:13Z

2

XElement x = XElement.Parse("<rewriteMaps><rewriteMap name=\"StaticRewrites\" /><add key=\"/superstar2011\" value=\"/article.aspx?articleid=4014\" /><add key=\"/superstar2012\" value=\"/article.aspx?articleid=4012\" /><add key=\"/superstar2012\" value=\"/article.aspx?articleid=4012\" /></rewriteMaps>");

var r = from i in x.Descendants("add")
                    select new { key = "key", value = "value" };

yourGrid.Datasource = r;
yourGrid.DataBind();

or like this example:

DataSet dataSet= new DataSet();
string filePath = Server.MapPath("your.xml");

dataSet.ReadXml(filePath);                    
yourGrid.DataSource = dataSet.Tables[0].DefaultView;
yourGrid.DataBind();

edited Jun 9, 2011 at 22:51

answered Jun 9, 2011 at 22:43

danyolgiax

13.2k10 gold badges71 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wicked Coder · Accepted Answer · 2011-06-09 22:57:07Z

0

You can consider using a XMLDatasource.

<asp:xmldatasource id="XmlDataSource1" runat="server" datafile="books.xml" />

and then Bind it to control as

<asp:TreeView id="TreeView1" runat="server" datasourceid="XmlDataSource1">
        <databindings>
          <asp:treenodebinding datamember="book" textfield="title"/>
        </databindings>
</asp:TreeView>

answered Jun 9, 2011 at 22:57

Wicked Coder

1,1186 silver badges8 bronze badges

Comments

Garrett Hyde · Accepted Answer · 2013-02-02 21:22:36Z

0

Read the xml file and collect the data in a datatable or dataset. Then bind the gridview with this datatable or dataset. Once the data is collected in a dataset or datatable, you can simply bind the gridview with the datatable or dataset via the following 2 lines:

GridView1.DataSource=ds;
GridView1.DataBind();

edited Feb 2, 2013 at 21:22

Garrett Hyde

5,7058 gold badges56 silver badges58 bronze badges

answered Feb 2, 2013 at 9:21

user2034765

11 bronze badge

Collectives™ on Stack Overflow

reading xml file in asp.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related