Home   |   QuickStart Welcome   |   ASP.NET   |   Web Services   |   How Do I...?   
  |   I want my samples in...      

ASP.NET 2.0 Quickstart Tutorials

Binding to Databases

One of the most common types of data to display in a Web application is data that comes from a SQL database such as Microsoft SQL Server, Oracle, or another OLEDB or ODBC data store. The SqlDataSource control represents a direct connection to a database in a Web application that data-bound controls can use to retrieve data automatically. SqlDataSource is intended to replace the ADO.NET code you would normally write in a page to create a connection and command to query a database. Because the data queries are specified directly as properties of the data source control, this is sometimes called a two-tier model, because the data queries are still maintained in page code. For this reason, the SqlDataSource control is usually aimed at small hobbyist or personal sites that do not require a fully encapsulated data middle-tier object. A later section of this tutorial discusses the ObjectDataSource control, which is targeted at larger enterprises with a need for middle-tier encapsulation of database queries.

The GridView Control

For the purposes of demonstrating how to bind to data from a database, the examples in this section take advantage of a new data-bound control called GridView. The GridView control is a new data-bound control in ASP.NET 2.0 for rendering data in a tabular grid format. Each row in the grid corresponds to a record of data and the columns represent the fields of the record. If you are familiar with the DataGrid control from ASP.NET v1.x, the GridView control is its replacement and supports a very similar object model.

The GridView control supports the following features:
  • Binding to data source controls.
  • Built-in sorting capabilities.
  • Built-in updating and deleting capabilities.
  • Build-in paging capabilities.
  • Built-in row selection capabilities.
  • Programmatic access to the GridView object model to dynamically set properties and handle events.
  • New column types such as CheckBoxField and ImageField.
  • Multiple data fields for the hyperlink columns.
  • Multiple data key fields for selection, updates, and deletes.
  • Customizable appearance through themes and styles.

Creating a Data Report

The simplest type of data-driven page is a read-only report, which displays data but does not allow the user to manipulate the presentation or modify the data. To create a read-only report against a SQL database, first configure a SqlDataSource on the page and then connect a data-bound control such as GridView to the data source by specifying its DataSourceID property. The example below shows a GridView control associated to a SqlDataSource control.

<form runat="server">
  <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" runat="server"/>
  <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    SelectCommand="SELECT [au_id], [au_lname], [au_fname] FROM [authors]"
    ConnectionString="<%$ ConnectionStrings:Pubs %>" />
The SqlDataSource ConnectionString property specifies the connection string to the database and the SelectCommand property specifies the query to execute to retrieve data. The connection string can be specified literally in the page, but in this case the property is assigned using a new expression syntax that retrieves the value from Web.config. In the example below, a GridView control is bound to a SqlDataSource control connected to a Microsoft™ SQL Server database.

VB GridView-SqlDataSource
Run Sample View Source

The SqlDataSource control is not limited to only connecting to Microsoft™ SQL Server database. It can actually connect to any managed ADO.NET provider configured as a System.Data.Common.DbProviderFactory. By default, there are four providers included in the .NET Framework machine.config:
      <add name="Odbc Data Provider" invariant="System.Data.Odbc" type="System.Data.Odbc.OdbcFactory, ..." />
      <add name="OleDb Data Provider" invariant="System.Data.OleDb" type="System.Data.OleDb.OleDbFactory, ..." />
      <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" type="System.Data.OracleClient.OracleClientFactory, ..." />
      <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" type="System.Data.SqlClient.SqlClientFactory, ..." />
The SqlDataSource ProviderName property can be set to the invariant name of any valid provider factory (it defaults to System.Data.SqlClient). Note that if you change the provider name, you will need to ensure the ConnectionString and SelectCommand properties use the correct syntax for the chosen provider.

In the preceding example, the GridView control reflected against the fields of the data records returned by SqlDataSource in order to dynamically generate the columns of the grid. You can also specify explicit column fields to display by adding DataControlField objects to the GridView's Columns collection. This allows you to specify exactly which columns to display and their relative order. The following example demonstrates a collection of BoundField and CheckBoxField objects in the GridView Columns collection. Other field types that can be assigned to this collection are ImageField, HyperLinkField, CommandField, ButtonField, and TemplateField.

VB GridView-SqlDataSource (BoundFields)
Run Sample View Source

The SelectCommand property of SqlDataSource can also be set to a stored procedure name instead of SQL command text. To enable this, set the SelectCommandType property to "StoredProcedure". The following example demonstrates the SqlDataSource control configured to select data from a stored procedure in the Northwind sample database.

VB GridView-SqlDataSource (Stored Procedure)
Run Sample View Source

By default, the SqlDataSource control returns a DataView from a DataSet object that contains the query results. You can configure the SqlDataSource control to return data as a DataReader instead by setting the SqlDataSourceMode property to "DataReader". Using a DataReader is generally more performant than a DataSet when you just need forward-only, read-only access to the data. However, note that the sorting capability of SqlDataSource will be disabled in this mode. The following example demonstrates the DataReader mode of SqlDataSource.

VB GridView-SqlDataSource (DataReader)
Run Sample View Source

Connection String Settings

In the preceding examples, SqlDataSource references the database connection string by name using a new declarative expression syntax in ASP.NET 2.0 that resolves to the connection string value at runtime. The connection string itself is stored in the Web.config file under a <connectionStrings> configuration section, so that it is easily maintained in a single location for all pages in the application.
    <add name="Pubs" connectionString="Server=(local);Integrated Security=True;Database=pubs;"
      providerName="System.Data.SqlClient" />
The following example shows the Web.config file used by the preceding SqlDataSource samples.

Connection Strings Configuration
View Source

Storing connection strings in Web.config is a recommended practice for any ASP.NET application, not only for centralized management, but also for the purpose of securing your connection strings. A command-line tool is available in ASP.NET 2.0 to encrypt this section for further security in a production environment. Refer to the Encrypting Configuration Sections topic of the management section of this tutorial for more detail on encrypting connection strings. This next example shows the Web.config file with an encrypted <connectionStrings/> section.

Connection Strings Configuration (Encrypted)
View Source
The SqlDataSource control's ConnectionString property is then set to the expression <%$ ConnectionStrings:Pubs %>, which is resolved by the ASP.NET parser to the connection string value at runtime. You can also specify an expression for the ProviderName property of SqlDataSource, for example <%$ ConnectionStrings:Pubs.ProviderName %>.

Sorting and Paging Data

One of the key advantages of the GridView control over other data-bound controls is its ability to automatically take advantage of data source capabilities. Instead of relying on page code to manually sort or page data, the GridView control can perform these operations automatically as long as the data source is configured to support these operations.

The SqlDataSource control supports sorting when its DataSourceMode property is set to "DataSet". To enable the sorting UI in the GridView, set the AllowSorting property to true. This causes the GridView to render link buttons for its column headers that can be clicked to sort a column. The GridView control passes the SortExpression associated with the column field to the data source control, which returns the sorted data to the GridView.

The SortExpression syntax expected by SqlDataSource is the same syntax as the Sort property of System.Data.DataView, although other data sources might support a different syntax. Because the sorting behavior of SqlDataSource relies on the underlying DataView Sort property, sorting is only supported by SqlDataSource when in DataSet mode; if set to DataReader mode, sorting will be disabled. Typically you will set the SortExpression to a single field name associated with a column of the GridView. The GridView automatically alternates between appending "ASC" or "DESC" to the SortExpression on each click, to toggle between ascending and descending sort order.

VB GridView Sorting
Run Sample View Source

You can also enable paging UI in the GridView by setting the AllowPaging property to true. The GridView can automatically page over any return value from a data source that supports the ICollection interface. The DataView returned by SqlDataSource when in DataSet mode supports this interface, so GridView can page over the result. When in DataReader mode, the GridView cannot page over the data returned by SqlDataSource. The following example demonstrates the GridView paging UI against a SqlDataSource in DataSet mode.

VB GridView Paging
Run Sample View Source

You can also customize the style and settings for the pager by configuring the PagerStyle and PagerSettings properties, respectively. PagerStyle determines the look and feel of the pager, whereas PagerSettings determines the type of paging to use (Numeric or Next/Previous buttons), the pager position, and related options. The following example demonstrates a few of these styles and settings applied to the GridView pager.

VB GridView Pager Settings
Run Sample View Source
Note that the paging operation in the preceding example is being performed entirely by the GridView control over the DataView returned by SqlDataSource, which supports the ICollection interface. In this case, the GridView retrieves all of the data records from the data source, renders a subset of the rows, and then discards the remaining rows. This is sometimes called "UI paging" because the logic for paging is happening in the rendering layer of the GridView control. While convenient for paging over arbitrary collections, this is not necessarily the most efficient way to page over data. It is also possible to configure paging at the data source interface level, so that GridView requests only as many rows as it needs from the data source in order to render the current page. The SqlDataSource control does not support interface-level paging at this time. The ObjectDataSource control does support this feature, and it is discussed in the Advanced Sorting and Paging topic of this tutorial.

Updating and Deleting Data

Just like sorting and paging, the GridView control can also automatically render UI for modifying data through Update and Delete operations, provided the associated data source is configured to support these capabilities. The SqlDataSource control supports Update operations when its UpdateCommand property is set and Delete operations when its DeleteCommand property is set to a valid update or delete command or stored procedure. The UpdateCommand or DeleteCommand should contain parameter placeholders for each value that will be passed by the GridView control (more on this below). You can also specify an UpdateParameters or DeleteParameters collection to set properties for each parameter, such as the parameter data type, input/output direction, or default value. These collections are discussed in more detail in subsequent topics.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
  ConnectionString="<%$ ConnectionStrings:Pubs %>"
  SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]"
  UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [state] = @state WHERE [au_id] = @original_au_id"
  DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @original_au_id"/>
To enable the UI in the GridView for Updates or Deletes, you can either set the AutoGenerateEditButton and AutoGenerateDeleteButton properties to true, or you can add a CommandField to the GridView control and enable its ShowEditButton and ShowDeleteButton properties. The GridView supports editing or deleting one row at a time. For editing, the user places the row in edit mode by clicking the Edit button, and then confirms the Update by clicking the Update button while the row is in edit mode. The user can also click the Cancel button to abort the edit operation and return to read-only mode. The following example shows the a GridView and SqlDataSource configured for updating data rows.

VB GridView Updating
Run Sample View Source
An important property that plays a special role in Update and Delete operations is the DataKeyNames property. This property is typically set to the names of fields from the data source that are part of a primary key used to match a given row in the data source. Multiple keys are comma-separated when specifying this property declaratively, although it is common to only have on primary key field. The values of fields specified by the DataKeyNames property are round-tripped in viewstate for the sake of retaining original values to pass to an Update or Delete operation, even if that field is not rendered as one of the columns in the GridView control. When the GridView invokes the data source Update or Delete operation, it passes the values of these fields to the data source in a special Keys dictionary, separate from the Values dictionary that contains new values entered by the user while the row is in edit mode (for update operations). The contents of the Values dictionary is obtained from the input controls rendered for the row in edit mode. To exclude a value from this dictionary, set the ReadOnly property to true on the corresponding BoundField in the Column collection. If you are using the GridView designer in Visual Studio, the ReadOnly property is set to true for primary key fields by default.

Notice the naming convention for parameters in the Update statement assigned to UpdateCommand. The automatic capability of GridView relies on this naming convention in order to work. Parameters that correspond to new values (entered by the user while the GridView row is in edit mode) are named the same as the associated field value returned by the SelectCommand. Parameters that correspond to the old values of the row (before the row was placed in edit mode), are given an "original_" prefix.

The GridView control passes its Keys and Values dictionaries separately to the data source, so that the SqlDataSource can apply these parameters separately to the underlying ADO.NET command object that will be executed for the operation. The names of the parameters in these dictionaries correspond to the names of the fields returned by the SqlDataSource SelectCommand. By default, the SqlDataSource re-formats parameter names from the Keys dictionary with the "original_" prefix, in order to differentiate them from the new values. The prefix applied to Keys parameters can be customized by setting the SqlDataSource OldValuesParameterFormatString property to a valid .NET Framework format string. It is set to "original_{0}" by default, but if you wanted to remove the formatting (for example, if you know your keys and new values parameter names never conflict), you could set this to "{0}".

For Delete operations, the SqlDataSource only applies the Keys dictionary by default (there are no new values for a delete operation), prepending the OldValuesParameterFormatString to the key parameter names.

Filtering Data

A common scenario in data-driven page is the ability to filter data in a report. For example, suppose the user could select from a set of field values in a DropDownList to filter the report grid to only display rows with a matching field value. In ASP.NET v1.x, you would have needed to perform the following steps in code:
  1. Cancel databinding in Page_Load if the request is a postback
  2. Handle SelectedIndexChanged event
  3. Add DropDownList SelectedValue to command�s Parameters collection
  4. Execute the command and call DataBind
In ASP.NET 2.0, this code is eliminated through the use of declarative Data Parameter objects. A data parameter allows external values to be declaratively associated with data source operations. These parameters are usually associated with a variable in a command expression or property, for example a parameter in a SQL statement or stored procedure for SqlDataSource. Data source controls expose parameter collection properties that can contain parameter objects for each supported data operation. For example:
<asp:DropDownList ID="DropDownList1" ... runat="server"/>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  ConnectionString="<%$ ConnectionStrings:Pubs %>"
  SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors] WHERE [state] = @state">
    <asp:ControlParameter Name="state" ControlID="DropDownList1" PropertyName="SelectedValue" />
The following example demonstrates a QueryStringParameter used to obtain a parameter value from the querystring of the request URL:

VB Filter By QueryString
Run Sample View Source

The next example demonstrates a ControlParameter used to obtain a parameter value from a DropDownList control on the page:

VB Filter By DropDownList
Run Sample View Source
You can configure data parameters to retrieve values from any of the following sources:

Name Description
  Parameter The Parameter class is the common base from which all other Parameter types are derived. The Parameter class also serves as the implementation for static parameters, where the value is specified statically using the DefaultValue property.

Parameters share a common Name property, which is the name of the parameter for the particular data source operation (for example, this would match a parameter name in the SelectCommand for the SqlDataSource). All Parameters also share a Type property which specifies the type of the parameter value.

Parameters also share a Direction property, which is used to specify whether the Parameter is used for Input, Output (or ReturnValue), or both Input and Output. Data sources generally expose output parameters and return values from an event args passed to the data source operation�s status event. Refer to the Working With Parameters topic of this tutorial for an example.
  QueryStringParameter The QueryStringParameter class binds the value of a querystring field to the value of the Parameter object. The QueryStringField property matches the name of the querystring field from which the value is retrieved. The DefaultValue property will be returned whenever the querystring value is unavailable.
  ControlParameter The ControlParameter class binds the value of a Control property to the value of the Parameter object. The ControlID property matches the ID of the Control whose property is bound to the parameter. The PropertyName specifies the property of the control from which the actual value is retrieved. The Control whose ID is specified by ControlID may optionally define a ControlValuePropertyAttribute, which determines the default property name from which to retrieve the control�s value. This property will be used whenever PropertyName is not set explicitly. ControlValuePropertyAttribute is applied to the following control properties:
  • Label.Text
  • TextBox.Text
  • ListControl.SelectedValue (for example, DropDownList)
  • CheckBox.Checked
  • Calendar.SelectedDate
  • DetailsView.SelectedValue
  • GridView.SelectedValue
  • TreeView.SelectedValue
  • FileUpload.FileBytes
  SessionParameter The SessionParameter class binds the value of a Session object to the value of the Parameter object. The SessionField property matches the name of the Session key from which the value is retrieved. The DefaultValue property will be returned whenever the Session value is unavailable.
  FormParameter The FormParameter class binds the value of an HTML form field to the value of the Parameter object. The FormField property matches the name of the form field from which the value is retrieved. The DefaultValue property will be returned whenever the Form value is unavailable.
  CookieParameter The CookieParameter class binds the value of an HttpCookie to the value of the Parameter object. The CookieName property matches the name of the cookie from which the value is retrieved (only simple-valued cookies are supported). The DefaultValue property will be returned whenever the cookie value is unavailable.
  ProfileParameter The ProfileParameter class binds the value of a User Profile object to the value of the Parameter object. The ParameterName property matches the name of the profile property name from which the value is retrieved. The DefaultValue property will be returned whenever the property value is unavailable. Form more information, refer to the User Profiles section of this tutorial.

Note the difference between data parameters that evaluate against an external source (Control, QueryString, etc) and the parameters that are passed for Update, Insert and Delete operations from preceding examples. In the latter scenario, the parameter values are supplied dynamically by the data-bound control that invokes the Update operation, in this case the GridView control. For Update, Insert, and Delete operations you typically will not require data parameters associated to external values. However, you can include an <asp:Parameter> object (the base class for all data parameters) in the UpdateParameters, InsertParameters, or DeleteParameters collection of the data source in order to specify properties such as the Type, Direction, or DefaultValue (the value to use if the value passed by GridView is null), to be applied to the parameter values passed from the GridView control.

Caching Data

Another capability of data source controls is the ability to cache data automatically. Although you can still use the cache APIs to programmatically cache data, setting a few declarative properties on a data source control can accomplish the same result. To enable caching for the SqlDataSource control (and also ObjectDataSource, discussed later), set the EnableCaching property to true. You can specify the length of time (in seconds) to store an entry in the cache using the CacheDuration property. You can also set the CacheExpirationPolicy property to either Sliding or Absolute just as you can do from the cache API. Caching is only supported on the SqlDataSource control when the DataSourceMode property is set to "DataSet".

For example, if you set CacheDuration to 5, the SqlDataSource will retrieve data from the database on the first request to the page and store this data in the cache. For subsequent requests, the SqlDataSource will attempt to retrieve the cache entry to serve the request without going back to the original database. After 5 seconds (or perhaps earlier, if cache memory pressure is high), the cache entry will be purged and a subsequent request to the page causes SqlDataSource to go back to the database again (repeating the caching process with the new data).

The example below demonstrates caching with the SqlDataSource control. The TimeStamp column updates each time the query is executed, so you can see how often the data is retrieved from the database versus retrieved from the cache. Note that approximately every five seconds, the TimeStamp updates.

VB SqlDataSource Caching
Run Sample View Source

A keen observer may have noticed that the TimeStamp also updates every time a new value is selected for the DropDownlist filter on the page. The reason for this is that each unique set of parameters supplied to the SelectCommand results in a different query to the database, and consequently a separate entry in the cache (notice that if you select the same value in the DropDownList twice within a 5 second timeframe, the TimeStamp is the same for that parameter value).

An alternative approach that works well for smaller data queries is to select all the data from the database initially for placing in the cache, and then filter over the single cache entry for different parameter values. To support this scenario, the SqlDataSource control supports a FilterExpression property and corresponding FilterParameters collection. Instead of applying parameter values to the command itself (as is the case with SelectParameters), the filter expression is applied to the RowFilter property of the DataView object returned from executing the command. The expression syntax must match the expected syntax for the DataView Row Filter property.

You can insert placeholders for parameter values into a FilterExpression using the standard .NET Framework format string syntax, for example "{0}", "{1}", and so on. At runtime, the SqlDataSource control applies the values of parameters specified in the FilterParameters collection to the FilterExpression by formatting the string with the values. Note that the parameter values are not escaped, so you'll need to wrap the parameter placeholders in single-quotes for String types.
<asp:DropDownList ID="DropDownList1" ... runat="server"/>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  ConnectionString="<%$ ConnectionStrings:Pubs %>"
  SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]">
  FilterExpression="state = '{0}'"
    <asp:ControlParameter Name="state" ControlID="DropDownList1" PropertyName="SelectedValue" />
The following example demonstrates this filtering technique in action.

VB Filtering Cache Entries
Run Sample View Source

Caching data is always a tradeoff between performance (not going back to the database on each request) and stale data (because the cache entry contains a snapshot of the data captured at a specific time). It is common for pages to use relatively low CacheDuration values in order to ensure that cache data is somewhat current. A more ideal situation would be to only invalidate cache entries when the underlying data in the database changes. As long as the data has not changed, there is no reason to purge the cache entry.

A new feature in ASP.NET 2.0 called SQL Cache Invalidation enables you to configure a data source to cache data indefinitely (or for a specified duration) until the data in the database changes, at which time the cache entry is purged. This technique allows you to use much higher values for CacheDuration and still guarantee that the data displayed always matches the values in the database. SQL Cache Invalidation is only supported on Microsoft™ SQL Server databases. There are two implementations of SQL Cache Invalidation: a notification-based implementation supported on SQL Server 2005 and a polling-based implementation supported on earlier versions of SQL Server. The SQL Cache Invalidation section of this tutorial describes the steps required to configure either of these implementations.

Once SQL Cache Invalidation is configured, you can use it from a data source control by specifying the SqlCacheDependency property of the data source. If using the polling-based implementation, this value accepts a format of the form connectionName:tableName. If using the notification-based implementation, set this property to "CommandNotification".

In this next example, the CacheDuration is set to "Infinite" and SqlCacheDependency is specified. Notice that the TimeStamp column does not update until the data is modified using the Edit button on the GridView.

VB Data Source SqlCacheInvalidation
Run Sample View Source

Master-Details and the DetailsView Control

You have seen in the Filtering Data section how data source controls can accept parameter values from external sources, such as other controls on the form, querystring values, and so on. A similar technique can be employed to build a master-details scenario. Master-details typically refers to an arrangement of controls where a selected record in one control (the "master" control) displays additional details for the selected record in another control (the "details" control). The additional details may be properties of the same data item, or may be related records associated to the master data item through a foreign key relationship in the database.

The GridView control supports a SelectedValue property, which indicates the currently selected row in the GridView. The SelectedValue property evaluates to the value of the first field specified in the DataKeyNames property. You can enable the UI for selection on the GridView by setting the AutoGenerateSelectButton to true, or by adding a CommandField with ShowSelectButton set to true to the GridView Columns collection. The SelectedValue property of GridView can then be associated to a ControlParameter in a data source for querying the details records, in much the same way that filtering was configured for a DropDownList in preceding examples.

To display details for the currently selected row, you could use another GridView control, but ASP.NET also includes a new DetailsView control that is uniquely suited for this purpose. The DetailsView control renders a single record at a time instead of a collection of records. Like the GridView, DetailsView renders in a tabular format, except the rows correspond to each data field (like GridView columns). The fields are specified in the DetailsView Fields collection. The DetailsView can also optionally page over a collection of records in the same manner as GridView paging (in DetailsView, the PageSize is always 1).

VB Master-Details w/ GridView and DetailsView
Run Sample View Source

DetailsView supports editing just like GridView, and you can enable the UI the same way using the AutoGenerateEditButton or CommandField.ShowEditButton properties. Of course, the data source associated to the DetailsView must also be configured to support the Update operation (in this case, by specifying an UpdateCommand on SqlDataSource). The following example demonstrates a DetailsView configured to support editing records in a master-details scenario.

VB DetailsView Editing
Run Sample View Source

Normally data-bound controls automatically re-bind to their data source whenever the data source changes (for example after an update). However, in the preceding example, the DetailsView is bound to a different data source than the GridView, so when the Update operation is invoked, only the DetailsView receives a change event from its data source. To force the GridView to also re-bind when the DetailsView performs an update, you can call DataBind() explicitly on GridView in the DetailsView ItemUpdated event. This example also handles events to disable editing when a GridView sorting or paging operation occurs or when a new filter value is selected in the DropDownList control.

It is also common to split master-details display across several pages in a Web application. To do this, you can add a hyperlink to each row of the GridView to navigate to a separate details page, passing arguments along the querystring. In the details page, the data source bound to DetailsView would accept these arguments using a QueryStringParameter object.

A hyperlink may be added to the GridView by adding a HyperLinkField object to the GridView Columns collection. The HyperLinkField Text property sets the test to display for the hyperlink (for example "View Details..."), while the NavigateUrl property specifies the URL to navigate when the link is clicked. Rather than specify a static URL for all rows, it is more common to specify NavigateUrlFields to be used in the construction of a dynamic URL. NavigateUrlFields can be set declaratively to a comma-separated list of fields from the data source. The NavigateUrlFormatString property specifies a standard .NET Framework format string for the URL, using placeholders like {0} and {1} to substitute the field values at runtime.

This next example demonstrates a master-details scenario using GridView and DetailsView in separate pages. Unlike the previous examples that showed the GridView and DetailsView bound to the same type of record (an author), this example shows different types of records for the master and details controls (authors and books), associated by a foreign key relationship in the underlying database. Because an author record may have more than one associated book, the DetailsView has been configured to support paging over the book records in the details page.

VB Master-Details (Separate Pages)
Run Sample View Source

Inserting Data

Like the GridView control, the DetailsView control supports Updating and Deleting data through its data source. However, DetailsView also supports Inserting data, whereas GridView does not. You can easily pair a DetailsView with GridView to enable inserting records to be displayed in the GridView control.

To enable the SqlDataSource to support Inserts, set the InsertCommand property to a valid insert command, with parameter placeholders for each field value that is rendered by the DetailsView in Insert mode. You can also optionally specify an InsertParameters collection to contain data parameter objects for this operation.

To enable the UI for inserting, set the AutoGenerateInsertButton property to true or add a CommandField with ShowInsertButton set to true to the DetailsView Fields collection. To place the DetailsView in insert mode, click the "New" button. DetailsView renders input controls for each field when in insert mode. Note that fields marked as ReadOnly are rendered as input controls in Insert mode (although they would not for Update mode). To exclude a field from Insert mode, set the InsertVisible property of the field to false. To commit an insert operation, click the "Insert" button while in insert mode. To abort the insert operation, click the "Cancel" button.

When an Insert operation is committed, the DetailsView collects the values from its input controls and populates a Values dictionary to pass to the data source. The SqlDataSource applies these values to the InsertCommand's parameters collection before executing the command. As with Updates, the automatic insert capability relies on parameters in the InsertCommand that are named exactly the same as the fields returned from the select operation. Note that the Keys dictionary (and consequently, the "original_" prefix for parameters) is not required for insert.

VB Master-Details Insert
Run Sample View Source

You can place the DetailsView on a separate page to perform an Insert or Update operation. The following example shows a DetailsView configured on a separate page for Insert and Updates. Notice that the DefaultMode property is set in this example to Insert or Edit so that the DetailsView renders in this mode initially instead of read-only mode. After an Insert or Update operation is performed, DetailsView always reverts to the DefaultMode (which is ReadOnly, by default).

VB Master-Details Insert (Separate Pages)
Run Sample View Source