Click here to Skip to main content
15,888,610 members
Home / Discussions / C#
   

C#

 
AnswerRe: TextBox. How to Validate for Number?? Pin
Dan Neely13-Oct-05 6:52
Dan Neely13-Oct-05 6:52 
GeneralRe: TextBox. How to Validate for Number?? Pin
...---...13-Oct-05 8:03
...---...13-Oct-05 8:03 
GeneralRe: TextBox. How to Validate for Number?? Pin
Dan Neely13-Oct-05 9:27
Dan Neely13-Oct-05 9:27 
GeneralRe: TextBox. How to Validate for Number?? Pin
Anonymous13-Oct-05 13:02
Anonymous13-Oct-05 13:02 
AnswerRe: TextBox. How to Validate for Number?? Pin
Anonymous13-Oct-05 16:21
Anonymous13-Oct-05 16:21 
AnswerRe: TextBox. How to Validate for Number?? Pin
nps_ltv13-Oct-05 17:22
nps_ltv13-Oct-05 17:22 
AnswerRe: TextBox. How to Validate for Number?? Pin
Luis Alonso Ramos13-Oct-05 17:29
Luis Alonso Ramos13-Oct-05 17:29 
AnswerRe: TextBox. How to Validate for Number?? Pin
albCode13-Oct-05 20:56
albCode13-Oct-05 20:56 
QuestionComboBox - Set first display item in dropdown list Pin
--Ian13-Oct-05 5:51
--Ian13-Oct-05 5:51 
AnswerRe: ComboBox - Set first display item in dropdown list Pin
miah alom13-Oct-05 7:37
miah alom13-Oct-05 7:37 
GeneralRe: ComboBox - Set first display item in dropdown list Pin
--Ian13-Oct-05 8:49
--Ian13-Oct-05 8:49 
AnswerRe: ComboBox - Set first display item in dropdown list Pin
--Ian14-Oct-05 10:47
--Ian14-Oct-05 10:47 
Questionprocess security question Pin
devmaximus13-Oct-05 5:00
devmaximus13-Oct-05 5:00 
AnswerRe: process security question Pin
Dave Kreskowiak13-Oct-05 6:47
mveDave Kreskowiak13-Oct-05 6:47 
GeneralRe: process security question Pin
devmaximus13-Oct-05 11:02
devmaximus13-Oct-05 11:02 
QuestionA4 size Richtextbox Pin
AB777113-Oct-05 4:22
AB777113-Oct-05 4:22 
QuestionTerminate Application after a given time of inactivity? Pin
Gulfraz Khan13-Oct-05 4:14
Gulfraz Khan13-Oct-05 4:14 
AnswerRe: Terminate Application after a given time of inactivity? Pin
Luis Alonso Ramos13-Oct-05 17:32
Luis Alonso Ramos13-Oct-05 17:32 
GeneralRe: Terminate Application after a given time of inactivity? Pin
Gulfraz Khan14-Oct-05 0:55
Gulfraz Khan14-Oct-05 0:55 
QuestionCatching application start/close events Pin
Trickster-SWE13-Oct-05 2:58
Trickster-SWE13-Oct-05 2:58 
AnswerRe: Catching application start/close events Pin
XRaheemX13-Oct-05 3:50
XRaheemX13-Oct-05 3:50 
GeneralRe: Catching application start/close events Pin
Trickster-SWE13-Oct-05 4:00
Trickster-SWE13-Oct-05 4:00 
QuestionHow To add/Show icons to the main menu items? Pin
majidbhutta13-Oct-05 2:23
majidbhutta13-Oct-05 2:23 
AnswerRe: How To add/Show icons to the main menu items? Pin
Gulfraz Khan13-Oct-05 2:35
Gulfraz Khan13-Oct-05 2:35 
QuestionDo you know the answer? Pin
Gulfraz Khan13-Oct-05 2:22
Gulfraz Khan13-Oct-05 2:22 
Hello!

I am sorry if I am unable to state my problem clearly.

I am using an SQL Server 2000 database for my .NET Windows application(VB/C#).
My main MDI form has a large number of menus and options.


Do I use a table in the database for maintaining the users and their encrypted password and other details?
i.e User ID, Full Name, Password, Working Shift, Email Address etc.
OR
I must use SQL Server logins and roles?

If I use the first approach my triggers and stored procedures will not be able to utilize the User_Name() SQL Server function for logging the User transactions.
If I use the second approach, then, where do I store the detailed information about the user (i.e infomation about the user as in Windows Active Directory for a domain)


In most of the forms in my application each form is related to a single table of the database. And each of those forms performs Update, Insert, Delete operations on the table.
How do I enable/disable the Insert, Update, Delete buttons on my form accoring to the user permissions on that table?



Does SQL Server's Application Role have something to do with my problem?
And
How do I use the Application Role best.


I hope you understand my problem.

Anticipating a quick reply.
Thank you.

-- modified at 8:23 Thursday 13th October, 2005

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.