Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
2.33/5 (3 votes)
See more:
In the SQL server table update or new entry happends, then one window should be flashed automatically in
certain client machines. Could you guide how to solve this requirement.
Posted
Updated 29-Nov-11 18:00pm
v4
Comments
Sergey Alexandrovich Kryukov 29-Nov-11 23:06pm    
Does "duding" mean "behaving like a dude"? :-)

OK, please explain what's "traction". How is this related to database? What does it mean "flash the information"?

--SA

if you have an sql depencendy what u cand o is call the Flashwindow api as the dependency changes. Its the best way :)
 
Share this answer
 
Hi Padhu,

since you didn't mention what version of SQL Server you are using I'll give you a solution that will work from SQL Server 2005 and upward. What you are looking for is called SqlDependency. See this related question on StackOverflow: http://stackoverflow.com/questions/342031/net-sql-server-database-monitoring-insert-update-delete[^].

Cheers!

—MRB
 
Share this answer
 
You can simply use the
VB
MsgBox("Your Message")
at the end of insertion...

Or Do like this...insert this code at the end of insertion...

VB
........

Dim f2 As New Form
f2.Show()
f2.StartPosition = FormStartPosition.CenterScreen
f2.FormBorderStyle = Windows.Forms.FormBorderStyle.None
f2.BackColor = Color.Blue
........


by executing this code one form will be shown to you...U can set other properties to make this form better....this is very simple solution...u can try...insert some text messages and all that....:)
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900