Recall that to support inserting, updating, and deleting, with the Object Data Source we needed to specify the object layer methods to invoke to perform the insert, update, or delete action.With the Sql Data Source, we need to provide SQL statements (or stored procedures) to execute.The following illustrations show some of the pages that you'll work with.When a new course entity is created, it must have a relationship to an existing department.
SELECT [Product ID], [Product Name], [Products].[Category ID], [Category Name], [Unit Price], [Discontinued] FROM [Products] INNER JOIN [Categories] ON [Products].[Category ID] = [Categories].[Category ID] ORDER BY [Product Name] SELECT [Product ID], [Product Name], [Products].[Category ID], [Category Name], [Unit Price], [Discontinued] FROM [Products] LEFT JOIN [Categories] ON [Products].[Category ID] = [Categories].[Category ID] ORDER BY [Product Name] value is translated into an empty string and the corresponding drop-down list item is selected.In previous tutorials we learned how the Object Data Source control allowed for inserting, updating, and deleting of data.The Sql Data Source control supports the same operations, but the approach is different, and this tutorial shows how to configure the Sql Data Source to insert, update, and delete data.Likewise, if at save the selected drop-down item is the empty string item then it is translated into a database This article was the third installment in this series that examined editing data with the data source controls in ASP. The Updating Basics installment examined the core concepts of editing, while Customizing the Editing Interface explored how to enhance the Grid View's editing experience.In this installment we built upon the demo created in the Customizing the Editing Interface article and saw how to handle ASP.In particular, we customized the editing interface so that when editing a product from the Northwind database, a user could select the product's category through a Drop Down List control rather than having to enter the actual value into a Text Box.