I have a GridView that displays data from a MS SQL database (duh!). I know the GridView allows you to have a command column with such functions as Edit, Update, Delete, etc., which I wish to use. The problem is that I only want these functions to be available to the user that is responsible for the particular data item. How could I go about doing that? The current user is stored as user.Identity.name and will be compared against an ID returned from the database for each item.

Also, I can not figure out how to add a confirm option for the delete function, such as setting the delete button's onclient click property to a javascript confirm message's return value. (assuming of course the button has an onclientclick property)