Pages

Thursday, November 29, 2007

ADO.NET 2.0 Data Source Controls

ASP.NET 2.0 has following data source controls :

SqlDataSource
AccessDataSource
ObjectDataSource
DataSetDataSource
XmlDataSource
SiteMapDataSource

SqlDataSource: Designed to work with SQL Server databases. It uses Sql Server .NET data provider internally. Sql Server .NET data provider classes are defined in the System.Data.SqlClient namespace.
The data source is SQL Server.

AccessDataSource: Designed to work with Microsoft Access. It uses OleDb data provider internally. OleDb data provider classes are defined in the System.Data.OleDb namespace.The data source is Microsoft Access.

ObjectDataSource : Designed to work with objects.
The data source is Object (usually classes provide a well-defined structure).

XmlDataSource: Designed to work with XML documents.The data source is XML documents.

SiteMapDataSource: Designed to work with SiteMap objects, which is a new concept in ASP.NET 2.0. The data source is SiteMap.

DataSetDataSource: Designed to work with DataSet objects.The datasource is dataset.

No comments: