How to Import Data from XML to GridView, How to Import XML to GridView

How to Import Data from XML to GridView

In this tutorial i will let you know how to import data from xml to gridview.In this first we have to upload the xml file , after upload the file will be worked as a data source for gridview and it will be shown in gridview.

Design For XML to GridView:-

01<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
02<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
03<html xmlns="http://www.w3.org/1999/xhtml">
04<head runat="server">
05    <title></title>
06    <style type="text/css">
07        .style1
08        {
09            width: 900px;
10        }
11    </style>
12</head>
13<body>
14    <form id="form1" runat="server">
15    <div>
16        <table align="center" class="style1">
17            <tr>
18                <td>
19                    Choose Your XML File:-<asp:FileUpload ID="FileUpload1" runat="server" />
20                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
21                    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Upload" />
22                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
23                    <asp:Label ID="Label1" runat="server"></asp:Label>
24                </td>
25            </tr>
26            <tr>
27                <td>
28                    <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC"
29                        BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal"
30                        Width="100%">
31                        <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
32                        <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
33                        <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
34                        <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
35                        <SortedAscendingCellStyle BackColor="#F7F7F7" />
36                        <SortedAscendingHeaderStyle BackColor="#4B4B4B" />
37                        <SortedDescendingCellStyle BackColor="#E5E5E5" />
38                        <SortedDescendingHeaderStyle BackColor="#242121" />
39                    </asp:GridView>
40                </td>
41            </tr>
42        </table>
43    </div>
44    </form>
45</body>
46</html>

Code For XML to GridView:-

01using System;
02using System.Collections.Generic;
03using System.Web;
04using System.Web.UI;
05using System.Web.UI.WebControls;
06using System.IO;
07using System.Data;
08 
09public partial class _Default : System.Web.UI.Page
10{
11    protected void Page_Load(object sender, EventArgs e)
12    {
13 
14    }
15    protected void Button1_Click(object sender, EventArgs e)
16    {
17 
18        if (FileUpload1.HasFile)
19        {
20            string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
21            string filextension = Path.GetExtension(FileUpload1.PostedFile.FileName);
22            if (filextension == ".xml")
23            {
24                string pathname;
25                pathname = Server.MapPath("xmlfiles/" + filename);
26                FileUpload1.PostedFile.SaveAs(pathname);
27                DataSet ds = new DataSet();
28                ds.ReadXml(Server.MapPath("~/Xmlfiles/"+FileUpload1.FileName));
29                GridView1.DataSource = ds;
30                GridView1.DataBind();
31            }
32            else
33            {
34                Response.Write("Not a valid XML file");
35            }
36 
37        }
38 
39    }
40}

Read data from XML

Enjoy:)