what is difference betwn sqlcommand.parameters.add() and sqlcommand.parameters.addwithvalue()

Question

we can use both the method while passing parameters to sql query ? then wht is the difference between them?

Community · Accepted Answer · 2020-06-20 09:12:55Z

5

The MSDN article on AddWithValue() explains the difference between the 2. Within is the explaination on the subtle differences.

AddWithValue replaces the SqlParameterCollection.Add method that takes a String and an Object.

The overload of Add that takes a string and an object was deprecated because of possible ambiguity with the SqlParameterCollection.Add overload that takes a String and a SqlDbType enumeration value where passing an integer with the string could be interpreted as being either the parameter value or the corresponding SqlDbType value.

Use AddWithValue whenever you want to add a parameter by specifying its name and value.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 3, 2011 at 6:27

p.campbell

101k70 gold badges264 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CHANDRAHAS Over a year ago

this means it will not check wht data is been supplied to it. it will give the data directly to query if the parameter is int and i am supplying it string it will directly take it it will not give any error

Collectives™ on Stack Overflow

what is difference betwn sqlcommand.parameters.add() and sqlcommand.parameters.addwithvalue()

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related