Welcome to K.Mohan Kumar's Blog: November 2011

Populating Grid Control from XML File

In this article, I am going to teach you, how to populate grid view control using a XML File as Data Source.For using Customer.xml as data source, please refer my article “Populating Grid Control ,XML File and XSD File From Database”.

Procedure:-

Add Customer.xml file using my article “Populating Data In XML And Grid” for populating grid control
I have used ReadXml( ) to read the data content in my XML File.
Server.MapPath( ) is used to get the exact location of the corresponding file.

Default.aspx

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Sample Program To Populate Grid Control Using XML File</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" AllowPaging="true"

GridLines="None" onpageindexchanging="GridView1_PageIndexChanging">

</asp:GridView>

</div>

</form>

</body>

</html>

Default.aspx.cs

using System;

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;

using System.Data.Sql;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection conn = new SqlConnection("Data Source=CTS;uid=sa;pwd=home;Initial Catalog=northwind");

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

loadMyGridFromXML();

}

public void loadMyGridFromXML()

{

conn.Open();

DataSet ds = new DataSet();

ds.ReadXml(Server.MapPath("Customers.xml"));

GridView1.DataSource = ds;

GridView1.DataBind();

conn.Close();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

loadMyGridFromXML();

}

Happy Coding.Explore more and more as possible.

To Download this article source code,click the below download link. For your convinience, I have attached Northwind Database script with this zip file.

Server1:

http://www.4shared.com/file/S2s_SnNm/Populating_Grid_Control_from_X.html

Server2:

http://www.mediafire.com/?r9887l3fxn0mbd2

For more articles, follow my blog:-

http://dotnetwithmohan.blogspot.com

Populating Grid Control ,XML File and XSD File From Database

In this article, I am going to teach you,how to populate grid view control using a XML File as Data Source.

For using Customer.xml as data source, please refer my article “Populating Data In XML And Grid”.

Procedure:-

I have used WriteXml( ) and WriteXMLSchema( ) to write the data content to my XML File and to write the data content to my XSD File respectively..
Server.MapPath( ) is used to get the exact location of the corresponding file.

PopulateDataInXML.aspx

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Program Illustrating To Populate Data In Gridcontrol and In XML</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" AllowPaging="true"

GridLines="None" onpageindexchanging="GridView1_PageIndexChanging">

</asp:GridView>

</div>

</form>

</body>

</html>

PopulateDataInXML.aspx.cs

using System;

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;

using System.Data.Sql;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection conn = new SqlConnection("Data Source=CTS;uid=sa;pwd=home;Initial Catalog=Northwind");

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

loadMyGridAndXML();

}

public void loadMyGridAndXML()

{

conn.Open();

SqlDataAdapter sda = new SqlDataAdapter("select * from customers",conn);

DataSet data = new DataSet();

sda.Fill(data, "customers");

data.WriteXml(Server.MapPath("Customers.xml"));

data.WriteXmlSchema(Server.MapPath("Customers.xsd")); GridView1.DataSource = data;

GridView1.DataBind();

conn.Close();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

loadMyGridAndXML();

}

When you run the above PopulateDataInXML.aspx page, what you get is:-

1.GridView gets populated J

2.Customers.xml and Customers.xsd will be auto – coded since you use WriteXml() and WriteXmlSchema() functions. J

Your XML Output Looks Like This:-

Customers.xml :-

<?xml version="1.0" standalone="yes"?>

<CustomerID>ALFKI</CustomerID>

<CompanyName>Alfreds Futterkiste</CompanyName>

<ContactName>Maria Anders</ContactName>

<ContactTitle>Sales Representative</ContactTitle>

<Address>Obere Str. 57</Address>

<City>Berlin</City>

<Country>Germany</Country>

</customers>

<CustomerID>ANATR</CustomerID>

<CompanyName>Ana Trujillo Emparedados y helados</CompanyName>

<ContactName>Ana Trujillo</ContactName>

<ContactTitle>Owner</ContactTitle>

<Address>Avda. de la Constitución 2222</Address>

<City>México D.F.</City>

<Country>Mexico</Country>

</customers>

// Since Customer table contains,91 records, similar to the above it appears..Each and every record will be placed inside a new <customers></customers> tag.

<CustomerID>WOLZA</CustomerID>

<CompanyName>Wolski Zajazd</CompanyName>

<ContactName>Zbyszek Piestrzeniewicz</ContactName>

<ContactTitle>Owner</ContactTitle>

<Address>ul. Filtrowa 68</Address>

<City>Warszawa</City>

<Country>Poland</Country>

</customers>

</NewDataSet>

Customers.xsd

<?xml version="1.0" standalone="yes"?>

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="customers">

<xs:complexType>

<xs:sequence>

<xs:element name="CustomerID" type="xs:string" minOccurs="0" />

<xs:element name="CompanyName" type="xs:string" minOccurs="0" />

<xs:element name="ContactName" type="xs:string" minOccurs="0" />

<xs:element name="ContactTitle" type="xs:string" minOccurs="0" />

<xs:element name="Address" type="xs:string" minOccurs="0" />

<xs:element name="City" type="xs:string" minOccurs="0" />

<xs:element name="Region" type="xs:string" minOccurs="0" />

<xs:element name="PostalCode" type="xs:string" minOccurs="0" />

<xs:element name="Country" type="xs:string" minOccurs="0" />

<xs:element name="Phone" type="xs:string" minOccurs="0" />

<xs:element name="Fax" type="xs:string" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>

Happy Coding.Explore more and more as possible.

To Download this article source code,click the below download link. For your convinience, I have attached Northwind Database script with this zip file.

Server1 : http://www.4shared.com/file/W6rwJ9Ck/Populating_Grid_Control_XML_Fi.html

Server2: http://www.mediafire.com/?glp8vnhcq012ig3

For more articles, follow my blog:-

http://dotnetwithmohan.blogspot.com

Saturday 26 November 2011

Populating Grid Control from XML File

Populating Grid Control ,XML File and XSD File From Database