Program Illustrating To Populate Data In Gridcontrol and In XML

--- title: "Populating Grid Control, XML File and XSD File From Database" description: "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, p" author: "mohan kumar" published: 2011-11-29 updated: 2020-03-04 canonical: https://www.mindstick.com/articles/826/populating-grid-control-xml-file-and-xsd-file-from-database category: "asp.net" tags: ["asp.net"] reading_time: 2 minutes --- # Populating Grid Control, XML File and XSD File From Database In this article, I am going to teach you, how to populate [grid view](https://www.mindstick.com/articles/53/data-grid-view) control using a [XML File](https://www.mindstick.com/articles/75/how-to-read-and-write-xml-file-through-c-sharp) as [Data Source](https://www.mindstick.com/forum/160659/how-do-you-create-a-custom-filter-to-filter-any-text-in-the-data-source-in-angularjs).\ For using Customer.xml as data source, please refer my article “Populating Data in XML and Grid”. ##### Procedure:- 1. 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. 2. [Server.MapPath](https://www.mindstick.com/forum/2132/server-mappath-in-asp-dot-net)( ) is used to get the exact location of the corresponding file. ##### PopulateDataInXML.aspx ``` <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> Program Illustrating To Populate Data In Gridcontrol and In XML

``` 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](https://www.mindstick.com/articles/873/update-delete-edit-gridview-in-asp-dot-net) gets populated J 2. [Customers](https://www.mindstick.com/articles/44795/easy-ways-to-reach-more-customers).xml and Customers.xsd will be auto – coded since you use WriteXml() and WriteXmlSchema() functions. ##### Your XML Output Looks Like This:- ##### Customers.xml :- ``` ALFKI Alfreds Futterkiste Maria Anders Sales Representative

Obere Str. 57

Berlin 12209 Germany 030-0074321 030-0076545 ANATR Ana Trujillo Emparedados y helados Ana Trujillo Owner

Avda. de la Constitución 2222

México D.F. 05021 Mexico (5) 555-4729 (5) 555-3745 ``` // Since Customer table contains, 91 records, similar to the above it appears. Each and every record will be [placed inside](https://www.mindstick.com/forum/12672/binding-all-college-names-to-a-college-dropdownlist-based-on-data-selected-in-another-city-dropdownlist-both-dropdownlists-are-placed-inside-the-datalist) a new tag. ``` WOLZA Wolski Zajazd Zbyszek Piestrzeniewicz Owner

ul. Filtrowa 68

Warszawa 01-012 Poland (26) 642-7012 (26) 642-7012 ``` Customers.xsd \ ``` ``` ##### Design View Of Customers.xsd: ![Populating Grid Control, XML File and XSD File From Database](https://www.mindstick.com/mindstickarticle/112c98e0-103f-4a68-8be5-07ac2dcadc5f/images/92c69b91-88f3-4495-9aeb-0fd9f3c6b5ee.png) ##### And Your Grid looks like :- ![Populating Grid Control, XML File and XSD File From Database](https://www.mindstick.com/mindstickarticle/112c98e0-103f-4a68-8be5-07ac2dcadc5f/images/8ca7eb4c-f3c6-4c33-96ad-47858c4dc740.png) Happy Coding.Explore more and more as possible. To Download this article [source code](https://www.mindstick.com/forum/23271/is-there-a-way-to-get-the-source-code-from-an-apk-file),click the below [download link](https://answers.mindstick.com/qa/95147/i-received-a-pdf-file-via-whatsapp-i-want-to-know-from-where-it-was-downloaded-can-i-get-the-download-link-from-the-pdf-file). For your convinience, I have attached Northwind [Database](https://www.mindstick.com/articles/71/how-to-create-xml-file-of-database-in-c-sharp) script with this zip file. **Server1:** http://www.4shared.com/file/W6rwJ9Ck/Populating_Grid_Control_XML_Fi.html **Server2:** http://www.mediafire.com/?glp8vnhcq012ig3 --- Original Source: https://www.mindstick.com/articles/826/populating-grid-control-xml-file-and-xsd-file-from-database Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.