5
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
10y
2.3k
0
Reply
    Saurav Kunal
    Parameters.Addwithvalues("param1",value)
    Saurav Kunal
    10y
    1
    sapna sinha
    Parameters.Addwithvalues("param1",value)
    sapna sinha
    10y
    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
    10y
    1
    arvind
    Parameters.Addwithvalues("param1",value) is best.
    arvind
    10y
    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
    10y
    0
Message