Khargesh Rajput
Which method is best to pass parameteres in stored procedure. Using Hashtable input.Add("param1",value) or Parameters.Addwithvalues("param1",value)
By Khargesh Rajput in ASP.NET on Jan 11 2015
  • Saurav Kunal
    Mar, 2015 19

    Parameters.Addwithvalues("param1",value)

    • 1
  • sapna sinha
    Feb, 2015 14

    Parameters.Addwithvalues("param1",value)

    • 1
  • Mohit Sharma
    Feb, 2015 5

    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

    • 1
  • arvind
    Jan, 2015 21

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

    • 1
  • Sujeet Suman
    Jul, 2015 19

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

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS