Setting a trigger parameter

  • Thread starter Thread starter cameljs18
  • Start date Start date
C

cameljs18

I have a trigger in my DB with a parameter called @User_Name , I want
to be able to set this param value from my C# app how can i do this?
thanks
 
A trigger with a parameter?

Maybe I've missed something in SQL, but surely a trigger is fired
indirectly by DML statements, hence no parameters?

Do you mean a stored procedure? If so, you'll need to indicate how
your DAL works; are you using SqlCommand directly? or using LINQ?
NHibernate? SqlDataAdapter?

Marc
 
Triggers are invoked from internal to the database entities. Thus, your
requirement is at the wrong place. Perhaps you have try this in different
format.
 
Back
Top