what is trigger?

Question

hi, can you send me trigger source in asp.net(c#)

Jignesh Trivedi · Answer

hi Ram, Are talking About "Trigger in SQL Server" Or Trigger in Ajax? A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. It is a database object which is bound to a table and is executed automatically. You can't explicitly invoke triggers. The only way to do this is by performing the required action no the table that they are assigned to. Please refer SQL Server: http://technet.microsoft.com/en-us/library/ms189799.aspx http://www.databasejournal.com/features/mssql/article.php/3837541/DML-Triggers-in-SQL-Server-2008.htm Ajax: In AJAX, we can specify areas of a page to be refreshed without refreshing the whole page. For this, we use UpdatePanels, which also have the ability to make use of triggers. These triggers allow us to specify which control initiates a certain postback. We can choose to initiate a partial postback, or a full one. http://www.ajaxtutorials.com/ajax-tutorials/using-updatepanel-triggers-in-asp-net-3-5/ http://www.asp.net/web-forms/tutorials/aspnet-ajax/understanding-asp-net-ajax-updatepanel-triggers hope this will hekp you.

Satyapriya Nayak · Answer

Hi Ram, Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. Triggers can't be invoked on demand. They get triggered when the associated INSERT, DELETE or UPDATE is performed. Please refer the below links http://www.c-sharpcorner.com/uploadfile/shashikantray/create-delete-and-update-triggers-in-a-database/default.aspx http://www.codeproject.com/Articles/25600/Triggers-Sql-Server Thanks