ASP.NET DataBound Controls - Details View

ASP.NET : DataBound Controls - Details View

In this tutorial you will learn DetailView DataBound Control, To create a file system Web site, Connecting to SQL Server, Use a Drop-Down List as the Master and To test the drop-down list.

The DetailsView is a control that is complementary to the GridView control. It has been introduced in ASP.NET 2.0 to provide an ability to work with a single record or row from an associated data source. The default view of this control is vertical with each column of the record displayed on a line of its own. It is used for updating and inserting new records and used often in the Master-details scenario where the details of the record selected in the master is displayed in detail.

The DetailsView, like the GridView rides on the data source capabilities to update, insert or delete rows. It renders a single data item at a time even when the data source exposes more items. If the data object represents the ICollection interface or the underlying data source exposes the paging operation, the DetailsView can page over the data, provided the AllowPaging property is set to true. Users can also navigate between rows of data using this control.

The process of binding the DetailsView control to a data source is very simple. The DataSourceID property can be set declaratively or programmatically.

The AutoGenerateEditButton property, if set to True, enables editing operations and the DetailsView renders the edit button in addition to the other columns in the control. The Edit mode can be invoked pressing this button. The Edit user interface can be customized using Styles, DataControlField objects and templates.

The DetailsView control can be configured to display a Delete and insert button also. The AutoGenerateInsertButton, when set to true, generates a New button. The new button invokes the insert mode and appropriate user interfaces are rendered including the fields in the DataKeyNames collection. Using this collection the data source control can locate the unique row to be updated.

The DetailsView control user interface can be customized using Style properties such as HeaderRowStyle, RowStyle, AlternatingRowStyle and so on. Templates also can be used to customize this control. EmptyDataTemplate, HeaderTemplate, FooterTemplate and PagerTemplate are some of the templates available for this control.

A number of events can be used to customize the code including pre and post insert, update and delete data source events. This includes ItemCreated and ItemCommand events. There is no selected event in the DetailsView control as the current event is treated as the selected event.

The Control can also be used for rendering mobile devices.

Let us explore the potential of using DetailsView control by creating and executing a page that has such a control on it.

To create a file system Web site

1. Open Visual Web Developer.

2. On the File menu, click New Web Site.

3. The New Web Site dialog box appears.

4. Under Visual Studio installed templates, click ASP.NET Web Site.

5. In the Location box, enter the name of the folder where you want to keep the pages of your Web site.

6. In the Language list, select C#.

7. Click OK.

8. Visual Web Developer creates the folder and a new page named Default.aspx.

Connecting to SQL Server

1. In Server Explorer (Database Explorer), right-click Data Connections and choose Add Connection.

2. The Connection Properties dialog box is displayed:

3. Do the following:

.......a. Enter or select the name of the SQL Server