I am new in ADO.Net and i am using C#. My problem is I want to execute one trigger in my program I am having name of student in my student table now from my C# program I will pass any name which is in table from textbox and that name should go to the trigger through update query. Here is the trigger and Update query -
Create trigger tr1 on student after update as begin update m set m.due_amount=m.due_amount-d.st_pay from master as m inner join inserted as d on d.st_name = m.st_name end update student set st_pay=500 where st_name='ram'
Can anyone help me how can I use this trigger and query in C#.
Thanx in advance with lots of expectation from this forum