Sql trigger not triggering in using C#?

Question

I am working on Inventory management system .I wanted to update two tables just after inserting into one table so i have done it using SQL After insert trigger but this trigger is not firing from C# which is the front end of my application.I dont know how to fire a trigger from C#.Can anyone help me as i have to submit this project by coming Sunday? Here is my SQL trigger..

CREATE TRIGGER tbl_Sales_ForInsert
ON SALES 
FOR INSERT
AS
BEGIN



  DECLARE @ITEMMODEL varchar(100)
      SELECT @ITEMMODEL = @ITEMMODEL FROM inserted
      update SALES set PROFIT=TOTAL_PRICE - (SELECT QUANTITY FROM SALES WHERE ITEM_MODEL=@ITEMMODEL) * (SELECT RATE FROM ITEM_DETAILS WHERE ITEM_MODEL=@ITEMMODEL) WHERE ITEM_MODEL=@ITEMMODEL
      UPDATE ITEM_DETAILS SET QUANTITY=QUANTITY-(SELECT QUANTITY FROM SALES WHERE ITEM_MODEL=@ITEMMODEL) WHERE ITEM_MODEL=@ITEMMODEL
      UPDATE ITEM_DETAILS SET AMOUNT = AMOUNT - (SELECT RATE FROM ITEM_DETAILS WHERE ITEM_MODEL=@ITEMMODEL) * (SELECT QUANTITY FROM SALES WHERE ITEM_MODEL=@ITEMMODEL) where ITEM_MODEL=@ITEMMODEL
    END

And this triggers just fine if you insert a new record in the server? — Hanlet Escaño
– Hanlet Escaño, Commented Feb 18, 2014 at 21:01
I'd check if your trigger fires is you do an insert manually. Don't try to attempt everything at once. Isolate the problem and then move on. — u84six
– u84six, Commented Feb 18, 2014 at 21:09
Perhaps something that might affect others is that BulkCopy will not fire triggers by default for performance reasons. See here. — Elaskanator
– Elaskanator, Commented Nov 14, 2018 at 15:48

Crono · Accepted Answer · 2014-02-18 21:01:50Z

1

Trigger should fire regardless of client. You should try to profile the executing Sql with Sql Profiler. Also, try executing your TSQL code directly in Management Studio and see what happens.

answered Feb 18, 2014 at 21:01

Crono

10.5k6 gold badges47 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mbonney · Accepted Answer · 2014-02-19 00:51:38Z

0

One approach is to test your trigger in your SQL database first. Create the trigger using your script (which looks to be correct) then add some data to the Sales table and see if the data in the Sales and item_details tables are updated. Once you know that the trigger is working and populating correctly, then work on the call for C# to insert new records into your Sales table. The trigger will fire automatically once you insert a new row into the Sales table.

answered Feb 19, 2014 at 0:51

mbonney

12 bronze badges

Comments

Kretos · Accepted Answer · 2014-02-19 17:35:47Z

0

Problem was @ITEMMODEL in the SELECT statement .I wrote :

 SELECT @ITEMMODEL = ITEM_MODEL FROM inserted

and it is working fine now .

answered Feb 19, 2014 at 17:35

Kretos

911 gold badge3 silver badges10 bronze badges

Collectives™ on Stack Overflow

Sql trigger not triggering in using C#?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related