Hi,
Please Suggest Which method is best to pass parameteres in stored procedure.
Using Hashtable input.Add("param1",value) or Parameters.Addwithvalues("param1",value)
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.
Sibeesh VenuPosted Jan 19, 2015, 8:49 AM
I always uses parameters.addwithvalue.
Please read here :
http://weblogs.sqlteam.com/dang/archive/2008/02/18/Why-Parameters-are-a-Best-Practice.aspx
Please accept and up vote if it helped you.
Kindest Regards
Sibeesh
http://sibeeshpassion.com/