I want to access data from my table, but since there are a few runtime parameters, I'll be defining the datasource (most likely with SqlDataAdapter, unless a better option exists) in the code behind file. I have a role for each of the 4 SQL commands (CRUD). So, if a user has a "ReadRole", they can access the page. If they have a "UpdateRole" they can edit, etc. A user can have all 4, or most combinations of them ("ReadRole" is the minimum required).
Now, I want to show my data in an "Access-like" way. That is, one record at a time, with Next/Previous/First/Last controls. There has to be a possibility of limiting the buttons (delete/edit/new) depending on the roles. Also, it is required that one of the fields is a calendar control (or similar).
What is the best control I can use to do this? I have no problem in doing most of the code, if that's the most effective way to accomplish what I require. However, it is essential that I can have absolute control over who does what.