How to use MS Sql Server2000 Trigger event with C#.NET Window Application.

I m developing a window application using C#.NET. I want to display the updated entry from MS SQL Server2000 database on the form using trigger in MS Sql Server2000. Can anyone tell me to catch the event that fired in SQL Server database (Trigger Event) when a new row insert. I want to use "Trigger reflection" in my C#.NET code so that i can display the updated database record without resending the request to database.
ddiproAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
spprivateConnect With a Mentor Commented:
You cannot catch a database trigger in the client.To show updated records you have to hit the db every time.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have to agree with spprivate, you cannot do that.
0
 
ddiproAuthor Commented:
Is there any other way to do that...?
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
ursangelCommented:
I hope,
The trigger will be fired either for an insert or update/delete of a record in the DB.
while doing that DB update if it is through a stored procedure. try to return back the rowset upadted as the result of the stored procedure. i think this will help you to some extend in re hitting the DB again.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
TheLearnedOne:
unless you can come up with a suggestion how this could be implemented, you should revise your recommendation...
Last time I read the EE rules and guidelines, the <" No " can also be a correct answer> was still in there.
thanks for your time.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
 
PrutfuglCommented:
Have you considered SqlDependency or SqlCacheDependency?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.