Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

ASP.net VB.net - Chat style text box using SQL

Hi

I am busy creating a simple chat mechanism on my website. So far I have a text box
that the user can type a message in and click a Send button, which fires the message through to my SQL database. I then send a reply through to the database, but am not sure how the
ASP.net page will pick this question up.
Is there some kind of way to ceck for a new message in the database using a timer mechanism or perhaps some kind of emailing facility?
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If the message is inserted when the user clicks send, you can create a trigger that runs after the insert, sending a notification to you
Avatar of Murray Brown

ASKER

Hi YZlat. Is that trigger something that brings it back onto the page from SQL. I'm not sure how that would work
Thanks. Great answer!