Creating an editable List View control entails defining the editing interface via the and adding the Edit, Update, and Cancel buttons in the appropriate spots.

This article walks through creating an editable List View control, with the finished results available for download at the end of the article. (It is assumed that the reader is familiar with how to edit data using a data source control.

The reason is because the List View is defined by templates whereas the Grid View and Details View are defined by fields.

Visible = True Details View Bind Data() End Sub Protected Sub my Details View_Mode Changing(By Val sender As Object, By Val e As Details View Mode Event Args) Handles my Details View. Find Control("lbl Cus ID"), Label) str Cus ID = lbl Cus ID. Find Control("txt Edit Customer ID"), Text Box) '*** Email ***' Dim txt Name As Text Box = CType(my Details View.

However, due to lack technical expertise, I personally use an automated solution named Lepide Auditor for SQL server i.e.,( to audit all the changes made in SQL database in my work-station.

The working pattern of this tool is really very comprehensive that provides complete graphical report of all critical changes occurred into SQL server at granular level with real time monitoring.

How can I get the updated object when the user presses one of my other action buttons? Currently if we need to retrieve the Old Values and New Values and key values from the paramters collection ,the best means is utilize the details View's buildin Updating command.

And if you don't want to use the buildin edit/update/cancel button, of course we can use our own buttons, we can add a custom field and put our own submit or linkbutton in it.