Windows and Web Application in one Solution (about chatting)

Question

hello evryone. i have a project and need some ideas. the project is about chatting. there are two types of users. the one is admin and the other is just user. admins will send messge to user with a windows application however users will chat admins from an ASP.Net web page. users will not chat each other. only admin to user, user to admin. there is an sql databaase on our server. lets imagine the project. when admin sends message, the message fisrtly goes to databse and at this point en event will be fired from windows application to catch the admin message from the asp side. and whn user cathes this event admin message wiill be added to a control on ASP.Net web page. then usser will send a messga to admin. user message goes firstly to database and event will fired from ASP.net page. from windows application that event will be cought and user message will be shown to admin.

is there anything wrong here? can u share your better ideas please. and i am sorry for english. i hope i could give the what the aim is :(

nkay · Answer

thanks mmuch for your help...

Forgottenhart · Answer

i dont know of any function in sql that can call other apps... the best best is just to have the web page and the form do refreshes to see if there is new data... call DB if new data then read else end if

nkay · Answer

thanks forgettenheart. i want to fire some event as u say when the database is changed. to do this i sould use events in two projects. can sql fire events or sth like events to catch from two projects. otherwise i must reference to each other to use windowsApplication and web projects events thnaks a lot

Forgottenhart · Answer

that shouldnt be a problem.. .. just design it like they were two seperate project... one does not need the other... they just each need to be able to talk with the database and refresh when some new even is written to the database... that project actually give me an idea for one of my own. Good luck