troubleshooting Question

Best control for code-behind bound data

Avatar of Cluskitt
CluskittFlag for Portugal asked on
ASP.NETVisual Basic.NET
16 Comments2 Solutions303 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 2 Answers and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros