Difference with Parameters.Add and Parameters.AddWithValue

by

With Add() method you may restrict user input by specifying type and length of data – especially for varchar columns.

.Parameters.Add("@name",SqlDbType.VarChar,30).Value=varName;

In case of AddWithValue() (implicit conversion of value) method, it sends nvarchar value to the database.

More Related Contents:

  1. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  2. Determine if a number can be made with prepicked numbers and times
  3. MetadataException: Unable to load the specified metadata resource
  4. When should I use a List vs a LinkedList
  5. Controlling Volume Mixer
  6. Get the generated SQL statement from a SqlCommand object?
  7. How do I determine a mapped drive’s actual path?
  8. Get File Icon used by Shell
  9. How does inheritance work for Attributes?
  10. Is it necessary to manually close and dispose of SqlDataReader?
  11. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  12. How to find overlapping controls that I added to form?
  13. How to execute an SSIS package from .NET?
  14. Calling Oracle stored procedure from C#?
  15. What is a predicate in c#? [duplicate]
  16. Winforms: Application.Exit vs Environment.Exit vs Form.Close
  17. How to pass a table-value parameter
  18. The State of Linkers for .NET apps (aka “Please Sir, May I have a Linker” 2009 edition)
  19. Get the SourceControl of a DropDownMenu
  20. How to keep single SQL Server connection instance open for multiple request in C#?
  21. Compare compiled .NET assemblies?
  22. How to Start a Process Unelevated
  23. Can a PictureBox show animated GIF in Windows Application?
  24. Save Settings in VB.Net or C#
  25. How do you disable an item in listview control in .net 3.5
  26. How do I connect to a SQL database from C#?
  27. .NET Simulate Ctrl+Alt+Del Sendkeys
  28. List of exceptions that CAN’T be caught in .NET
  29. Are there any OK image recognition libraries for .NET?
  30. Detecting remote desktop connection

Leave a Comment