1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Difference Between Add() and AddWithValue() in ASP.NET,STORED PROCEDURE

Discussion in 'ASP.NET' started by shyam_oec, Nov 9, 2009.

  1. shyam_oec

    shyam_oec New Member

    Joined:
    Nov 26, 2007
    Messages:
    89
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    Software Developer, .NET Framework
    Location:
    Jamshedpur
    hi,
    please explain me what is the main difference between Parameters.Add() method and Parameters.AddWithValue() mathod while using StoredProcedure in ASP.NET using C#.I am using Oracle database.as both of them is used to insert value into database.
    thanks
     
  2. urstop

    urstop New Member

    Joined:
    Oct 17, 2007
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    0
    You can use any of the methods to add a parameter along with its value, but Add is deprecated because it has a similar overloaded method. So when using Add, you will have to be careful to make sure that the compiler understands that it is a value and not a SQLDBType. So its always better to use AddWithValue method. Check out this link from MSDN for reference.

    http://msdn.microsoft.com/en-us/lib...ient.sqlparametercollection.addwithvalue.aspx
     

Share This Page