how i can invoke C# method when sql trigger is fired ???
how i can invoke or call C# method when sql trigger is fired ???
plz i need help .
this is the first time for me here
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kirtan PatelPosted Aug 8, 2009, 5:19 PM
Thank you :)
Kirtan PatelPosted Aug 8, 2009, 5:51 PM
Thanks Again :)
abas shahenPosted Aug 8, 2009, 5:35 PM
abas shahenPosted Aug 8, 2009, 5:14 PM
Kirtan PatelPosted Aug 8, 2009, 5:09 PM
There is Noway you can invoke C# method using SQL Server but try idea like this
if tutor Uses C# Desktop application then
make also Tutor table For Showing Alert to Him When Student Submit His Assignment at that time Insert Message into TutorTable
Like Tutor(StudentId, ReadedAlert)
here Readed alert is only two value "True" or "False"
so when tutor Reads That Message in That Window and mark Alert as readed press "Ok" and that that record's AlertReaded updated in the TutorTable
now Tutor Application Checks for Unreaded Alerts for Some Time Intervals using timer and Fetch Records in Which ReadedAlert Field in Table is "False"
abas shahenPosted Aug 8, 2009, 4:57 PM
Kirtan PatelPosted Aug 8, 2009, 4:45 PM
can you tell me in which scenario need this type of code ? explain a lil bit more so that i can better understand your requirement :)
thank you