Technical Training
ASP.NET 2.0ASP.NET SqlDataSource Control
SqlDataSource Control
In this tutorial you will learn about The Data Source Wizard - SqlDataSource Control, the process of setting up the data source.
Ads
The Data Source Wizard
DataSource controls enable programmers to declaratively connect data sources to the user interface. The logic for retrieving the data from the source is inbuilt into the control. For instance when a DropDownList is added to the form the developer is prompted to connect to the DataSource. On Clicking ‘connect to DataSource’, the wizard is started to guide the user through the process of setting up the data source.

The user has to indicate whether an existing data source or a new data source has to be added.

The DataSource that can be added can be a SQL server database or a Microsoft Access Database or a DataSet object or an XML file. In this instance we shall create a new SQLDataSource. In the Choose a DataSource drop down box, select < New DataSource > The next screen of the wizard prompts the user select the type of data source required

The user has to select the database and specify an ID for the DataSource. Click Ok to continue.
A connection string will now have to be specified. The connection can be an existing string or a new string. Since there are no existing connections a new one will be created.

Click on New Connection to create the connection string. A number of options are given to the user. Select Sql Server DataBase file to connect to the SQL Server Express database.

ASP.NET 2.0
- Getting started with ASP.NET 2.0
- .NET Framework Fundamentals
- Microsoft.NET Framework Tools
- Application Development in .NET
- What's New in the .NET Framework 2.0 ?
- Introduction to Visual Studio.NET
- Installing Visual Studio.NET 2005
- Working with Visual Studio.NET Web Applications
- Whats New in ASP.NET 2.0
- Creating an ASP.NET Application
- ASP.NET Code Directory
- ASP.NET Page Object Model
- ASP.NET Server Controls
- ASP.NET Working With Master Pages
- ASP.NET Creating Content for Master Page
- ASP.NET Referencing Master Page Members
- ASP.NET Changing Master Pages Dynamically
- ASP.NET Creating Nested Master Pages
- ASP.NET Working with Web Parts
- ASP.NET Using Web Parts and Controls in Web Pages
- ASP.NET Web Pages and Layout
- ASP.NET - Adding Web Parts at Run Time
- ASP.NET Personalization: User Profiles and Themes
- ASP.NET Data Access features
- ASP.NET State Management
- ASP.NET Customizing the Session State Mechanism
- ASP.NET State Management And Caching
- ASP.NET Security
- Forms Authentication in ASP.NET
- ASP.NET Managing Membership and Roles
- ASP.NET Configuring Page-Level Caching
- ASP.NET Setting Application-Level Caching
- ASP.NET Data Source Object Model
- ASP.NET SqlDataSource Control
- ASP.NET Data Bound Controls
- ASP.NET GridView Control
- ASP.NET GridView Filtering
- ASP.NET Adding Sorting and Paging in GridView
- ASP.NET DataBound Controls - Details View
- ASP.NET Using a Grid to Display Detail Information
- ASP.NET Displaying Master-Detail Data on the Same Page
- Displaying Master-Detail Data on Separate Pages in ASP.NET
- ASP.NET Creating Web Wizards
- ASP.NET : Dynamic Image control
- ASP.NET Advanced Site Functionality







