In this blog I will talk about Data Sources in ASP.NET
A data source control communicates with the data-bound controls and hides the complex data binding methods. These are the tools that give data to the bound controls and support execution of operations like deletions, sorting,insertions and updates.
Each data source control wraps a specific data gives-relational database, XML documents or column classes and helps in:
1. Managing connection
2. Selection of data
3. Managing presentation aspects like paging, caching etc.
4. Manipulation of the data
There are several data source controls available in ASP.Net for taking data from SQL server, from ODBC or OLEDB servers, from XML files and from business objects.
The data source controls needed for hierarchical data are:
1. XMLDataSource : allows binding to strings and XML files with or without schema information.
2. SiteMapDataSource: allows binding to a provider that supplies site map data.
The data source controls used for tabular data are:
Data Source Controls Description
SqlDataSource Shows a connections to an ADO.Net data provider that returns SQL data, including data sources accessible via OLEDB and QDBC
ObjectDataSource Gives binding to a custom .Net business object that returns data
LinqDataSource Gives binding to the results of a linq-to-sql query
AccessDataSource It represents connection to a Microsoft Access database.
The Data sources Views
Data source views are objects of the DataSourceView class and show a customized view of data for different data operations like filtering, sorting etc.
The DataSourceView class serves as the base class for all data source view classes, which describes the capabilities of data source controls.
Example:
//XMLDataSource
<asp:XmlDataSourceID="XmlDataSource1"runat="server"DataFile="~/XMLFile.xml"></asp:XmlDataSource>//SiteMapDataSource
.config file
<configuration>
<system.web>
<compilationdebug="true"targetFramework="4.5" />
<httpRuntimetargetFramework="4.5" />
<siteMapdefaultProvider="XmlSiteMapProvider"enabled="true">
<providers>
<addname="XmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
siteMapFile="web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
</configuration>
//Web.SiteMap file
Right Click on application>>select ADD option>>New Item>>web>>siteMap
<siteMapxmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNodetitle="Home"url="~/home.aspx"description="Go To Home">
<siteMapNodetitle="Page 3"url="~/book3/chapter3/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter3/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter3/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter3/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
</siteMapNode>
</siteMapNode>
</siteMap>
//SQLDataSource
Click on Databind Control>>Choose data Source>>select new data source>>open source Configuration Wizard>>choose a data source type
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:MindStickTaskConnectionString %>"SelectCommand="SELECT * FROM [EmployeeDetail]"></asp:SqlDataSource>Example:
Create a MasterPage.Master
<%@MasterLanguage="C#"AutoEventWireup="true"CodeBehind="MasterPage.master.cs"Inherits="SitePathPath.MasterPage"%>
<!DOCTYPEhtml>
<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title></title>
<asp:ContentPlaceHolderID="head"runat="server">
</asp:ContentPlaceHolder>
</head>
<body>
<formid="form1"runat="server">
<div>
<h2>Basic SiteMapPath Sample</h2>
Use the Menu control on the left to navigate to different pages in the website.
Notice that the SiteMapPath control changes what is displayed. Click on links on the
SiteMapPath control to navigate up the hierarchy.
<br/><br/>
<tablecellpadding="8">
<tr>
<tdbgcolor="#ccffcc"valign="top"rowspan="2">
<b><i>Menu Control</i></b>
<br/><br/>
<asp:MenuDataSourceID="SiteMapDataSource1"ID="Menu1"runat="server"
StaticDisplayLevels="2"BackColor="#FFFBD6"
DynamicHorizontalOffset="2"Font-Names="Verdana"
ForeColor="#990000"StaticSubMenuIndent="10px">
<StaticSelectedStyleBackColor="#FFCC66"/>
<StaticMenuItemStyleHorizontalPadding="5px"VerticalPadding="2px"/>
<DynamicMenuStyleBackColor="#FFFBD6"/>
<DynamicSelectedStyleBackColor="#FFCC66"/>
<DynamicMenuItemStyleHorizontalPadding="5px"
VerticalPadding="2px"/>
<DynamicHoverStyleBackColor="#990000"Font-Bold="False"
ForeColor="White"/>
<StaticHoverStyleBackColor="#990000"Font-Bold="False"
ForeColor="White"/>
</asp:Menu>
<asp:SiteMapDataSourceID="SiteMapDataSource1"runat="server"/>
</td>
<tdwidth="10">
</td>
<tdbgcolor="#ffffcc"nowrap="noWrap"valign="top">
<b><i>SiteMapPath Control</i></b>
<br/><br/>
<asp:SiteMapPathID="SiteMapPath1"runat="server">
</asp:SiteMapPath>
</td>
</tr>
<tr>
<tdwidth="10">
</td>
<tdstyle="border-left-color: black; border-bottom-color: black;
width : 392px; border-top-style: solid; border-top-color: black;
border-right-style: solid; border-left-style: solid;
border-right-color: black; border-bottom-style: solid"
bgcolor="#ffcc00"valign="top">
<asp:contentplaceholderid="ContentPlaceHolder1"runat="server">
</asp:contentplaceholder>
</td>
</tr>
</table>
<br/><br/>
</div>
</form>
</body>
</html>
<%@PageTitle=""Language="C#"MasterPageFile="~/MasterPage.Master"AutoEventWireup="true"CodeBehind="Home.aspx.cs"Inherits="SitePathPath.Home"%>
<asp:ContentID="Content1"ContentPlaceHolderID="head"runat="server">
</asp:Content>
<asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"runat="server">
<br/>
Home<br/>
Page Content
</asp:Content>
Create a Web.SiteMap
Right Click on application>>select ADD option>>New Item>>web>>siteMap
<?xmlversion="1.0"encoding="utf-8" ?> <siteMap >
<siteMapNodetitle="Home"url="~/Home.aspx"description="Go To Home">
<siteMapNodetitle="Book 1"url="~/book1/book1.aspx"description="Go To Book 1">
<siteMapNodetitle="Chapter 1"url="~/book1/chapter1/chapter1.aspx"description="Go To Chapter 1">
<siteMapNodetitle="Page 1"url="~/book1/chapter1/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter1/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter1/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter1/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book1/chapter1/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter1/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter1/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter1/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book1/chapter1/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter1/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter1/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter1/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 2"url="~/book1/chapter2/chapter2.aspx"description="Go To Chapter 2">
<siteMapNodetitle="Page 1"url="~/book1/chapter2/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter2/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter2/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter2/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book1/chapter2/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter2/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter2/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter2/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book1/chapter2/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter2/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter2/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter2/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 3"url="~/book1/chapter3/chapter3.aspx"description="Go To Chapter 3">
<siteMapNodetitle="Page 1"url="~/book1/chapter3/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter3/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter3/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter3/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book1/chapter3/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter3/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter3/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter3/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book1/chapter3/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book1/chapter3/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book1/chapter3/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book1/chapter3/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Book 2"url="~/book2/book2.aspx"description="Go To Book 2">
<siteMapNodetitle="Chapter 1"url="~/book2/chapter1/chapter1.aspx"description="Go To Chapter 1">
<siteMapNodetitle="Page 1"url="~/book2/chapter1/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter1/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter1/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter1/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book2/chapter1/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter1/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter1/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter1/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book2/chapter1/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter1/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter1/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter1/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 2"url="~/book2/chapter2/chapter2.aspx"description="Go To Chapter 2">
<siteMapNodetitle="Page 1"url="~/book2/chapter2/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter2/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter2/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter2/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book2/chapter2/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter2/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter2/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter2/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book2/chapter2/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter2/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter2/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter2/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 3"url="~/book2/chapter3/chapter3.aspx"description="Go To Chapter 3">
<siteMapNodetitle="Page 1"url="~/book2/chapter3/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter3/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter3/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter3/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book2/chapter3/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter3/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter3/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter3/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book2/chapter3/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book2/chapter3/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book2/chapter3/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book2/chapter3/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Book 3"url="~/book3/book3.aspx"description="Go To Book 3">
<siteMapNodetitle="Chapter 1"url="~/book3/chapter1/chapter1.aspx"description="Go To Chapter 1">
<siteMapNodetitle="Page 1"url="~/book3/chapter1/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter1/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter1/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter1/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book3/chapter1/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter1/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter1/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter1/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book3/chapter1/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter1/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter1/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter1/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 2"url="~/book3/chapter2/chapter2.aspx"description="Go To Chapter 2">
<siteMapNodetitle="Page 1"url="~/book3/chapter2/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter2/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter2/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter2/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book3/chapter2/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter2/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter2/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter2/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book3/chapter2/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter2/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter2/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter2/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
<siteMapNodetitle="Chapter 3"url="~/book3/chapter3/chapter3.aspx"description="Go To Chapter 3">
<siteMapNodetitle="Page 1"url="~/book3/chapter3/page1/page1.aspx"description="Go To Page 1">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter3/page1/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter3/page1/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter3/page1/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 2"url="~/book3/chapter3/page2/page2.aspx"description="Go To Page 2">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter3/page2/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter3/page2/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter3/page2/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
<siteMapNodetitle="Page 3"url="~/book3/chapter3/page3/page3.aspx"description="Go To Page 3">
<siteMapNodetitle="Paragraph 1"url="~/book3/chapter3/page3/paragraph1.aspx"description="Go To Paragraph 1"/>
<siteMapNodetitle="Paragraph 2"url="~/book3/chapter3/page3/paragraph2.aspx"description="Go Paragraph 2"/>
<siteMapNodetitle="Paragraph 3"url="~/book3/chapter3/page3/paragraph3.aspx"description="Go Paragraph 3"/>
</siteMapNode>
</siteMapNode>
</siteMapNode>
</siteMapNode>
</siteMap>
<configuration>
<system.web>
<compilationdebug="true"targetFramework="4.5" />
<httpRuntimetargetFramework="4.5" />
<siteMapdefaultProvider="XmlSiteMapProvider"enabled="true">
<providers>
<addname="XmlSiteMapProvider"
description="SiteMap provider which reads in .sitemap XML files."
type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
siteMapFile="Web.sitemap"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
</configuration>
Output:
Leave Comment