objects, see Data Sets, Data Tables, and Data Views.
Whereas Data Table objects contain the data, the Data Relation Collection allows you to navigate though the table hierarchy.
However, this approach requires that we manually write out the SQL statements by hand, which can be monotonous and error-prone.
Fortunately, the Configure Data Source wizard provides an option to have the statements checkbox will only be checkable if the table selected has a primary key and the primary key column (or columns) are included in the list of returned columns.
With the Sql Data Source, we need to provide SQL statements (or stored procedures) to execute.
As we'll see in this tutorial, these statements can be created manually or can be automatically generated by the Sql Data Source s Configure Data Source wizard.
The data and schema can then be transported across HTTP and used by any application, on any platform that is XML-enabled.
You can save the schema as an XML schema with the Write Xml Schema method, and both schema and data can be saved using the Write Xml method.The results are then returned as either a Data Set or Data Reader, depending on the value of the control s value has been specified, the Enable Inserting, Enable Editing, or Enable Deleting option in the corresponding data Web control s smart tag will become available.To illustrate this, let s take an example from the table and a Grid View that renders this data.Once we add deleting support to the Grid View, the Grid View will automatically supply this parameter value, using the value of its property added, the Grid View s smart tag now contains the Enable Deleting option. As discussed in An Overview of Inserting, Updating, and Deleting, this causes the Grid View to add a Command Field with its .As Figure 4 shows, when the page is visited through a browser a Delete button is included. Figure 4: Each Grid View Row Now Includes a Delete Button (Click to view full-size image) Upon clicking a Delete button, a postback occurs, the Grid View assigns the Figure 5 depicts this interaction graphically.For now, let s use the Properties window in the Designer, although the Configure Data Source wizard or declarative syntax option would work just as well.