This VIDEO TUTORIAL will demonstrate on how to implement a customized data modification interface using a GridView data web control on CustomizedUI.aspx page of ‘EditInsertDelete’ folder of the project. This step of the video highlights on implementing an editable GridView control interface. A subset of the product information is used for editing and display purposes. ProductName is displayed as text box, Categories and Suppliers fields are shown as dropdownlists and Discontinued field is shown as radio buttons in the editable interface of the GridView control. In order to update or edit a subset of Product information, an overload of the ‘UpdateProduct’ method is added to the Products BLL class file. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL (included in Step 1) will elaborate on how to use the newly created ‘UpdateProduct’ method. A GridView control is added to the CustomizedUI.aspx page. The GridView control is configured to be bound to a new ObjectDataSource control which in turn uses the newly created UpdateProduct method for the UPDATE tab of the ObjectDataSource configuration wizard. In addition, the GridView control is customized to display only ProductName, Categories, Suppliers and Discontinued fields in the design mode. Finally, the run time display of the GridView control with product information is also observed. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will familiarize on how to display the Category Name and Suppliers Name fields in the editing interface of the GridView control. In order to accomplish this, the Category and Supplier bound fields in the GridView are converted to TemplateFields. Following which, two drop down lists are added to the corresponding EditItemTemplate Fields of the GridView. These dropdownlists are configured using separate ObjectDataSources which invoke the GetCategories ( ) and GetSuppliers ( ) methods from the CategoriesBLL and SuppliersBLL business objects respectively. For existing product information, the dropdown lists are pre-selected with existing CategoryID and SupplierID using the ‘databindings’ link from the smart tag menu of the dropdown lists. In addition, a separate list item as ‘None’ is added to be displayed in the dropdown lists to handle NULL values from the Products table in the database for existing product information. For detailed information and source code for this step, please refer to the original article.