Introduction to Asp.Net 2.0 - ASP.NET Database Tutorial

Home > Aspnet > Tutorials > Introduction to Asp.Net 2.0 - ASP.NET Database Tutorial

Tell a friend

Link to us

Total Members

Members: 84657

Sitemap

Forum

Chat

Home

ASP.NET Database Tutorial Home

1 . Introduction to Asp.Net 2.0

2 . Introduction to ADO.Net

3 . Connecting Access Database with AccessDataSource and GridView Control

4 . Accessing SQL SERVER Database [Using SqlDataSource]

5 . Storing Connection String in Web.Config File

6 . Inserting Records in Database

7 . Updating Records in Database

8 . Updating Records in Database

9 . Deleting Records from Database

10 . Execute Scalar: Getting Single Value from the Database

11 . Execute Reader: Fetching Records from Database

12 . Data Adapter

13 . Data Adapter and Database Connection

14 . Performing Batch Updates: Using SqlCommandBuilder

15 . Improving Performance using Stored Procedure

16 . Filtering and Sorting Data Using DataView/DataTable

17 . Data Binding and Data Synchronization

18 . SQL Transaction and Locking

19 . SQL Joins and .Net

20 . Automatically Generation of SQL Statement

Aspnet Group Home

Aspnet Discussion (10)

Aspnet Members (2382)

Aspnet Resources

Aspnet Source Code (388)

Aspnet Articles (1)

Aspnet Blogs

Aspnet Jobs

Aspnet Components (201)

- Aspnet Ask Question

- Aspnet Questions

- Aspnet Unanswered Questions

GROUPS

.NET

Java

Other

TUTORIALS

.NET

.NET Tutorial

ASP Tutorial

ASP.NET Database Tutorial

ASP.NET Development Tips

ASP.Net Security,Internationalisation And Deployment

ASP.NET Server Controls Tips

Web Development

Software Development

Java

Java Web Component Tutorial

JSP And J2EE Design Tutorial

RESOURCES

SUBMISSIONS

COMMUNITY

SITE

Aspnet database Tutorial

Introduction to Asp.Net 2.0

<< Aspnet Database Tutorial Home

Next: Introduction to ADO.Net >>

Some of the major changes that are there in Asp.Net 2.0 as compare to Asp.Net earlier version is the data-specific controls, which are divided into two groups: Data source controls and data-bound controls. Data source controls create the connection to stores of data (databases or other repositories). The data-bound controls take the information from the data source controls and create a rendering on the page.

A number of data source controls are available for many types of databases and even no relational data sources. Although additional controls are already in development by third parties, the following five data source controls ship with ASP.NET 2.0:

SqlDataSource control: To connect to the Microsoft SQL Server and other T-SQL databases that have a managed provider

AccessDataSource control: To connect to Microsoft Access files (extension of .MDB )

ObjectDataSource: To connect to middle-tier business objects

XmlDataSource: To connect XML content

SiteMapDataSource: To connect XML files in the format of the ASP.NET 2.0 site map (or site data through a custom provider)

Data-bound controls include many that are familiar from ASP.NET 1. x , as well as some that are completely new for ASP.NET 2.0:

GridView and DataGrid: For tabular data. GridView is new for version 2, whereas the legacy DataGrid remains largely unchanged for ASP.NET 1. x .

DetailsView and FormView: Display data for one record at a time.

DataList and Repeater: Display multiple data records in flexible layouts defined by the page programmer.

ListBox, DropDownList, BulletedList, CheckBoxList, and RadioButtonList: Display a group of options with the expectation that the user will make a selection.

AdRotator: Display an advertisement from a store of advertisements. This control was offered in ASP.NET version 1. x but has been updated to be compatible with data source controls.