Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#
I want to fire trigger when tables are updated..
How to create trigger in C#..
Posted 6-Apr-12 22:47pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

There is not any trigger creation "in" ASP.Net.
But you can create a trigger "through" your ASP.Net in the SQL-Server.
Many ways. For example:
Step 1: You must know the T-SQl syntax and command of creating trigger: Look at the link
Step 2: You must know about SQLCommand Class in C#. Loot at the link
Note: I really think it would be a pity if you don't use dynamic SQL Commands. You can create trigger in the SQL-Server through itself, when you are developing the application (not runtime).
Creating a trigger dynamically(!) will complicate your program and using dynamic commands maybe a security risk (Look at this)

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 458
1 OriginalGriff 294
2 George Jonsson 258
3 CPallini 160
4 Shemeemsha RA 140
0 OriginalGriff 5,985
1 Sergey Alexandrovich Kryukov 5,341
2 CPallini 4,760
3 George Jonsson 3,400
4 Gihan Liyanage 2,522

Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 7 Apr 2012
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