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
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
Hi, There is no difference in terms of functionality. In fact, both do this: return this.Add(new SqlParameter(parameterName, value)); The reason they deprecated the old one in favor of AddWithValue is to add additional clarity, as well as because the second parameter is object, which makes it not immediately obvious to some people which overload of Add was being called, and they resulted in wildly different behavior. Thanks