index > Windows Forms Designer > checking database without timer or thread

checking database without timer or thread

im developing an applicationin c#. there are two types of users, sayenduser and admin. i have a table to track the enduser login status. when an user loged in to the application a message should be send to the admin. i dont want to fire a query every second to check the user status using the timer. is there any other way to do so.
thanku

Binil MB Thursday, May 14, 2009 5:45 AM

SqlDependency

Thanks, A.m.a.L .Net Goodies
Remember to click "mark as answered" when you get a correct reply to your question

Marked As Answer byBinil MB Thursday, May 14, 2009 8:10 AM

A.m.a.L - aditi.com - Think Product Thursday, May 14, 2009 6:05 AM

So, do you have a Login Screen?
Sending a mail/ message just after code for validating Login could be one solution.

Hope, I have understood your query well.

Regards, Lakra :) - If the post is helpful or answers your question, please mark it as such.

Abhijeet Lakra Thursday, May 14, 2009 5:55 AM

SqlDependency

Thanks, A.m.a.L .Net Goodies
Remember to click "mark as answered" when you get a correct reply to your question

Marked As Answer byBinil MB Thursday, May 14, 2009 8:10 AM

A.m.a.L - aditi.com - Think Product Thursday, May 14, 2009 6:05 AM

thank you so much for ur reply. i do have a login screen. both the users have their interface, like mdi form. assume that admin is already logged in. when a user login from any other system, i need to show a messagebox with messagebox.show("") in the admin mdi form.

Binil MB Thursday, May 14, 2009 6:15 AM

can u give me some example code

Binil MB Thursday, May 14, 2009 6:35 AM

You can use google to search for other answers

Custom Search

More Threads

• Custom ToolBoxItem

• COM Interopt - is it all STA or single threaded?

• hosting compact fraework from in windows form designer

• Importing ActiveX Controls into .NET

• controls not rendering on the form

• Usercontrol rendering on wrong control?

• Custom form transparency problem

• How can I make my user control take my other controlslike a panel

• Enabling Design Time Events

• Adding Controls to a UserControl on a form