How to read Xml File Using gridview in asp.net
source Of xml file
<?xml version="1.0" encoding="utf-8" ?>
<EmployeeInformation>
<Employee>
<sno>101</sno>
<firstname>Pankaj </firstname>
<lastname>Lohani</lastname>
<address>hyderbad</address>
</Employee>
<Employee>
<sno>102</sno>
<firstname>sharath </firstname>
<lastname>Lohani</lastname>
<address>goa</address>
</Employee>
<Employee>
<sno>103</sno>
<firstname>rakesh </firstname>
<lastname>Lohani</lastname>
<address>delhi</address>
</Employee>
<Employee>
<sno>105</sno>
<firstname>rakkaj </firstname>
<lastname>shiva</lastname>
<address>hyderbad</address>
</Employee>
</EmployeeInformation>
ASpx.page (Design view):
------------------------
<asp:GridView ID="grddata1" runat="server">
</asp:GridView>
Aspx.cs (code View File)
ASpx.page (Design view):
------------------------
<asp:GridView ID="grddata1" runat="server">
</asp:GridView>
Aspx.cs (code View File)
protected voidPage_Load(object sender, EventArgs e)
{
var xmlfilepath = Server.MapPath("mydata.xml");
DataSet dsemp = newDataSet();
dsemp.ReadXml(xmlfilepath);
grddata1.DataSource = dsemp.Tables[0].DefaultView;
grddata1.DataBind();
}
