Search

Wednesday, October 14, 2015
0 comments

DataSet.ReadXml( ) method example in ASP.NET C#

12:01 AMWednesday, October 14, 2015
Introduction
In this article i will give an example of DataSet.ReadXml( ) method. Through this we can read xml file in ASP.NET C#. In this method we will pass xml file URL.
Description
I have explained more about xml like How to create xml sitemap in ASP.NET C#.

Introduction about XML

XML stands for xtensible markup language. It have many features such as:
  • Xml is used for carry data .
  • Xml structure is based on tree structure.
  • Xml is not a presentation language 
  • XML use user defined tags for making structre.
  • Xml language is a case-sensitive language. 
  • XML is a Text File 

Now at a time if you want to make a structural database in xml file then you follow some steps . these steps are:
Step-1: First defined root node like <bookstore> 
Step-2: Declare child node <bookstore> <book>
Now you can consider book tag is your table name which you create in SQL and bookstore represent the database name.
Step-3 : Declare your column name inside the <book> tag such as Title of the book, author and price of the book .
now your file look like that.
Book store tree
Step-4 repeat your step 2-3 again
Now your complete code is

<?xml version="1.0" encoding="utf-8" ?>
<bookstore>
  <book>
    <title>
      ASP.NET
    </title>
    <author>
      SCOTT
    </author>
    <price>
      20$
    </price>
  </book>
<book>
    <title>
      PHP
    </title>
    <author>
      JECOB
    </author>
    <price>
      20$
    </price>
  </book>


</bookstore>

Dataset

Dataset is a collection of data-Table. So easily you can bind any control with Dataset . Dataset is a class file which stored in System.Data namespace. Here in this example using Dataset we can read xml file from the source. 
lets take an example , How to bind GridView using XML file in ASP.NET


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default12.aspx.cs" Inherits="Default12" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Codebehind

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Default12 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("XMLFile.xml"));
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
}
Output
How to bind GridView using XML file in ASP.NET

Protected by Copyscape Online Copyright Protection Software

0 comments :

Post a Comment

 
Toggle Footer
Top