[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1148
  • Last Modified:

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.
0
ddipro
Asked:
ddipro
1 Solution
 
spprivateCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now