Determine who is connected to application

Question

0.00/5 (No votes)

See more:

I am looking for a way to determine who is connected to my windows application. First I looked at who was connected to the sql server but I read that will only show active users. So I guess I need a way to store the username when they log in into a table but remove it when they log off.

I will eventually want to put this information into a listbox or datagridview

I know ENVIRONMENT.USERNAME but not sure how to do this.

Posted 3-Feb-11 10:59am

wiswalld

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Accepted Answer · 2011-02-03T11:03:00

Solution 1

AFAIK Environment.UserName only gives the User of the Operating System on the particular machine it runs on.

(Don't know what happened there, got cut off mid-stream)

So your program could call Environment.UserName or My.User.Name and send that information to the database where it could store the Machine Name, User Name and Time.

(This is really odd 2nd time)
Then in the OnFormClosing event handler call it again and send that to the server where the logout time can be stored.

There is probably a better solution than this but this should work.

Posted 3-Feb-11 11:03am

Henry Minute

Updated 3-Feb-11 11:25am

v3

Comments

wiswalld 3-Feb-11 17:22pm

I thought about that and when they log off it would store the log off time. But I read that could really bloat my database. I would somehow need to delete that record when they log out.

Henry Minute 3-Feb-11 17:27pm

I don't know how many users you have but you could have a procedure that runs every day and deletes any user record over, say, 48 hrs old.

wiswalld 3-Feb-11 17:37pm

That looks like the way I will go