fetching data from the database

Question

0.00/5 (No votes)

See more:

I have one table called status table having userid name and status field .when one person logged in his user id and name will be stored in database and the status table is updated from 0 to 1.Then one more user will come and logged in and table updated.

So now i have logged in with say userid=2002 and name=abc i am using the system at present ,when another person logged in with his userid=say 2003 name=efg then userid 2002 should receive popup message as 2003 is online or currently logged in the application form as popup message

Actually this is a window based application

Can anyone please help this

Posted 17-Jun-10 0:01am

venkataramreddy

Updated 17-Jun-10 2:41am

v3

Add a Solution

2 solutions

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)

#realJSOP · Answer 1 · 2010-06-17T03:22:00

First, I would be really annoyed if I kept getting a popup message saying a new user has logged into the application. I would recommend a less intrusive notification mechanism.

As to your problem, I would simply make the application check the dabase to se who's logged in. Make it check automatically every 10 minutes or so. Also provide the user with a way to manually check (a menu item or button).

vipsha · Answer 2 · 2010-06-17T00:19:00

Solution 1

hi friend,

First of all please specify that your application is pure desktop or web with desktop?

Thanks,

Mahesh Patel