This VIDEO TUTORIAL and series of upcoming steps will demonstrate on how to implement to limit data modification functionality based on a particular user’s access. In other words, this video will elaborate on how to restrict access to modify particular supplier information based on the selection of a supplier in the drop down list on a web page. The suppliers’ dropdown list will include a list item that states ‘Show/Edit All Suppliers’ in addition to the list of remaining individual suppliers. If the end user selects Show/Edit All supplier’s list item, then he or she would have access to modify all the suppliers. However, if the end user selects a particular supplier from the dropdown list, then he or she would have access to modify only that particular supplier’s information. The step 1 of this video tutorial demonstrates this scenario by adding a Dropdown list and DetailsView control to the ‘UserLevelAccess.aspx’ page of ‘EditInsertDelete’ folder. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will show case on how to add a DetailsView control that displays all the suppliers information with and Edit link and paging when the end user selects the ‘Show/Edit All Suppliers’ list item in the drop down list. In order to accomplish a DetailsView control is added below the dropdown list and an ObjectDataSource titled ‘AllSuppliersDataSource’ that retrieves all the suppliers information from the database using ‘GetSuppliers( )’ method and updates the underlying database table using ’UpdateSupplierAddress( )’ from the SuppliersBLL object. This step will conclude by demonstrating the above functionality at runtime. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL (included in Step 2) will extend the previous step 2 to display a single supplier’s information in the DetailsView control based on a particular supplier’s selection by the end user in the dropdown list. In order to display the supplier information, a new ObjectDataSource titled ‘SingleSupplierDataSource’ that is configured using ‘GetSupplierBySupplierId( )’ method of SuppliersBLL business object. Similarly, the UpdateSupplierAddress method is mapped to the Update tab of the ObjectDataSource configuration wizard. In addition, an event handler for the ‘Suppliers’ dropdown list titled ‘Suppliers_SelectedIndexChanged’ is customized to dynamically assign ObjectDataSources to bind with the DetailsView control based on the selection made by the end user in the dropdown list. Finally, this newly created functionality of the UserLevelAccess.aspx web page examined at runtime. For detailed information and source code for this step, please refer to the original article.