5
Reply
Reply

Which method is best to pass parameteres in stored procedure. Using Hashtable input.Add("param1",value) or Parameters.Addwithvalues("param1",value)

Khargesh Rajput

Khargesh Rajput
Jan 11, 2015
2.2k
0
    Saurav Kunal

    Parameters.Addwithvalues("param1",value)

    Saurav Kunal
    March 19, 2015
    1
    sapna sinha

    Parameters.Addwithvalues("param1",value)

    sapna sinha
    February 14, 2015
    1
    Mohit Sharma

    Parameters.AddwithValues is a better option check the following for reference http://weblogs.sqlteam.com/dang/archive/2008/02/18/Why-Parameters-are-a-Best-Practice.aspx

    Mohit Sharma
    February 05, 2015
    1
    arvind

    Parameters.Addwithvalues("param1",value) is best.

    arvind
    January 21, 2015
    1
    Sujeet Suman

    We should use "Parameters.Addwithvalues("param1",value)" to pass parameter in stored procedure. Because it is secure & easy to program.

    Sujeet Suman
    July 19, 2015
    0