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

C#

 
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
AnswerRe: Do you know the answer? Pin
turbochimp13-Oct-05 20:17
turbochimp13-Oct-05 20:17 
QuestionCreate .EXE file Pin
zaboboa13-Oct-05 1:59
zaboboa13-Oct-05 1:59 
AnswerRe: Create .EXE file Pin
Dan Neely13-Oct-05 4:08
Dan Neely13-Oct-05 4:08 
AnswerRe: Create .EXE file Pin
Tom Larsen13-Oct-05 8:39
Tom Larsen13-Oct-05 8:39 
Questionmobile agent implementation Pin
sujeer00912-Oct-05 23:23
sujeer00912-Oct-05 23:23 
QuestionNested Datagrids Pin
Member 124072312-Oct-05 22:46
Member 124072312-Oct-05 22:46 
QuestionLoad Balanced Network Pin
Andre Trollip12-Oct-05 21:26
Andre Trollip12-Oct-05 21:26 
AnswerRe: Load Balanced Network Pin
XRaheemX13-Oct-05 3:54
XRaheemX13-Oct-05 3:54 
AnswerRe: Load Balanced Network Pin
Dave Kreskowiak13-Oct-05 6:25
mveDave Kreskowiak13-Oct-05 6:25 
QuestionTreeView selectedNode problem Pin
ppp00112-Oct-05 21:07
ppp00112-Oct-05 21:07 
AnswerRe: TreeView selectedNode problem Pin
mav.northwind12-Oct-05 23:21
mav.northwind12-Oct-05 23:21 
QuestionThe problem about Excel Automation add-ins(C#) Pin
dreamwinter12-Oct-05 20:48
dreamwinter12-Oct-05 20:48 
QuestionDisabling controls Pin
Brendan Vogt12-Oct-05 20:29
Brendan Vogt12-Oct-05 20:29 
AnswerRe: Disabling controls Pin
XRaheemX13-Oct-05 3:43
XRaheemX13-Oct-05 3:43 
AnswerRe: Disabling controls Pin
Dave Kreskowiak13-Oct-05 6:22
mveDave Kreskowiak13-Oct-05 6:22 
Questionalignment problem please help me its urgent Pin
arusmemon12-Oct-05 19:42
arusmemon12-Oct-05 19:42 
QuestionScrolling the RichtextBox Pin
AB777112-Oct-05 19:21
AB777112-Oct-05 19:21 

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.