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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nant script to run t-sql 1
Output parameter when using storedProcedure 14
DataBase trigger 2
using Like Operator with a parameter in a command text 3
Passing callbacks from a C# COM server to a C++ COM client 1
Trigger action in C# executable from web application 3
Using VBA to trigger a certain slide 0
Implementing an IDispatch Interfac in C# DLL 0

Back
Top