Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL VB.NET
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 29-Nov-11 18:01pm
Edited 29-Nov-11 19:00pm
v4
Comments
SAKryukov at 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
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

if you have an sql depencendy what u cand o is call the Flashwindow api as the dependency changes. Its the best way Smile | :)
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can simply use the
MsgBox("Your Message")
at the end of insertion...
 
Or Do like this...insert this code at the end of insertion...
 
        ........
 
        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....Smile | :)
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 390
1 Jochen Arndt 165
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,032
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,220


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 1 Dec 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100