The second code example demonstrates how to display data that is retrieved from a Microsoft SQL Server database in a Drop Down List control and update the record using a Text Box control.The following code example demonstrates how to use a Sql Data Source control to display data in a Drop Down List control and update data when the Submit button is clicked.
Regardless of what workflow is initiated, they all follow the same six steps: the firing of the appropriate pre-action event (, in the case of the updating workflow).
This article is one in a series of articles on ASP. While point-and-click data access is useful for prototyping and for beginners or hobbyists who have little to no programming experience, wizards and the like are generally frowned upon by more seasoned developers since they typically offer ease of use at the cost of extensibility and customizability. NET 2.0 data source controls, however, provide the best of both worlds, in my opinion - they can be quickly and easily configured to work with data, yet through a myriad of events that are raised during the data source controls' lifecycles, provide the flexibility for use in more advanced scenarios.
The Sql Data Source and Object Data Source controls are the two most commonly used data source controls, and they provide a means for retrieving and modifying data from either a database or object library, respectively.
The The following code example demonstrates how to display data that is retrieved from a SQL Server database in a Drop Down List control and update the record using a Text Box control.
The example shows how you can use a Db Transaction object to add transaction context when using the Sql Data Source control to update data.