1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    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

    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