Hi i have Created One Trigger How to use the Trigger in C#

Question

0.00/5 (No votes)

See more:

Dear Frieds,

Here i have Written one Trigger Concept in SqlServer and I want to Know how

to Call the Triggers in c# with Asp.net

My Triggers in Sql server:

SQL

ALTER trigger tr_insert
    on SchoolDetailsInfo
    after insert
    as
    begin
    
    declare @intSchoolId int= null
    declare @SchoolName varchar(30)=null
    declare @PrincipleName varchar(30)=null
    declare @LandlineNo varchar(30)=null
    declare @MobileNo varchar(30)=null
    declare @Address varchar(30)=null
    declare @DateofBirth varchar(30)=null
    declare @Flag varchar = null
    
    select @intSchoolId=intSchoolId from inserted
    select @SchoolName =strSchoolName from inserted
    select @PrincipleName=strPrincipleName from inserted
    select @LandlineNo =strLandLine from inserted
    select @MobileNo=strMobileNo from inserted
    select @Address =strAddress from inserted
    select @DateofBirth =intdate from inserted
    
    update SchoolDetailsInfo
    
    set strSchoolName='anil' where intSchoolId!=@intSchoolId
    end

So now i want to call the Trigger in asp.net with c#

Regards,

Anilkumar.D

Posted 25-Aug-11 19:55pm

Anil Honey 206

Updated 25-Aug-11 20:02pm

Suresh Suthar

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Shameel · Answer 1 · 2011-08-25T20:02:00

You cannot call the trigger directly from any code. The trigger is executed by the database when the event for which it is created happens. In your case, since it is an AFTER INSERT trigger, it will be executed after an insert happens on the table in which the trigger is created. You can insert data into the table using ADO.NET to run the trigger code.

C#

SqlCommand comm = new SqlCommand("INSERT INTO Table1 (Col1, Col2, Col3) VALUES (@Col1, @Col2, @Col3)", connection);
comm.Parameters.AddWithValue("@Col1", Col1Value);
comm.Parameters.AddWithValue("@Col2", Col2Value);
comm.Parameters.AddWithValue("@Col3", Col3Value);
comm.ExecuteNonQuery();

Suresh Suthar · Answer 2 · 2011-08-25T20:05:00

Solution 2

You can not use or call trigger using C#.
Trigger automatically executed in response to certain events on a particular table or view in a database.

Posted 25-Aug-11 20:05pm

Suresh Suthar

Comments

Anil Honey 206 26-Aug-11 2:17am

SO I Should Put any Condiction while Iam Creating Trigger.