What is the best way to display XML file in a table?

Hello r p,

I think I have the answer for your question.

As you need the code to remain unchanged even after the schema of the XML file is modified, Yes, there's a way.

Although DataTable doesn't facilitate you to read xml file, create schema and map the data to itself but DataSet does.

Now to answer your question, you can follow the sample code below to get this job done:
-------------------------------------

void BindXmlToGrid()
{
       DataSet ds = new DataSet();
     ds.ReadXml(@"D:\books.xml");
     GridView1.DataSource = ds.Tables[0];
     GridView1.DataBind();

}
----------------------------------------

As you can see, I didn't create any schema and it is mapped to the table at position 0 in dataset. So, this is the way you are seeking for. You don't need to bother about the changes in schema. Yes, do put a try catch block to check if schema is invalid and nothing is imported to DataSet.

Hope it Helps. Happy Coding :)

Cheers!

Hai Iftikar,
   this is thank u for this answer.I am also using this answer.
in asp page what header file  u use for XmlFile

you change the node you have to change the c# code also.

if you change node (create/update/delete) , then you need to change your code.

Regards,
Iftikar

try this one: here i am showing the xml file in gridview

ex:

 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Display_xmlfile_gridview_datatable._Default" %>



   


   

   

   
   
            Text="Show Xml Data" />
   

   

.CS Code File

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

namespace Display_xmlfile_gridview_datatable
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void btn_showdata_Click(object sender, EventArgs e)
        {
            string Path = Server.MapPath("Data.xml");
            DataTable dt = new DataTable("student");
            dt.Columns.Add("sid", typeof(System.String));
            dt.Columns.Add("sname", typeof(System.String));
            dt.Columns.Add("saddress", typeof(System.String));
            dt.Columns.Add("smarks", typeof(System.String));
            dt.ReadXml(Path);
            GridView1.DataSource = dt;
            GridView1.DataBind();

        }
    }
}

Data.xml file





   

        s001

        Raj

        Orissa

        100    

 

Hi,
        In your aspx


in you code


Regards,
Iftikar