In this article I will explain how to read the data from XML file and bind toGridView control using C# in ASP.Net.
I have as xml file with name as test.xml.
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<student>
<id> 1 </id>
<name>Rasik</name>
<gender>Male</gender>
<age>27</age>
</student>
<student>
<id>Thivan</id>
<name>male</name>
<gender>25</gender>
<age>Thivan</age>
</student>
</NewDataSet>
Design a gridview with name as GridView1 in BindGrid.aspx
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
Reading the XML file data and binding it to GridView control
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
BindGrid();
}
}
private void BindGrid()
{
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/test.xml"));
GridView1.DataSource = ds;
GridView1.DataBind();
}
Output:
Id | name | gender | age |
---|---|---|---|
1 | Rasik | Male | 27 |
2 | Thivan | male | 25 |
Post your comments / questions
Recent Article
- How to use if else statement in c++?
- How to use godaddy domain name with another godaddy hosting account?
- Restore of database 'DATABASE' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
- How to programmatically modifying the AppSetting value in web.config using c#?
- TypeError [ERR_INVALID_CALLBACK]: Callback must be a function. Received undefined
- How to calculate the age from jQuery ui datepicker using c#?
- How to calculate days difference between two dates in c#?
- Changing date format in jQuery ui datepicker
Related Article