Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlParameterCollection.Add Method (String, SqlDbType)

Adds a SqlParameter to the SqlParameterCollection given the parameter name and the data type.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

Public Function Add ( _
	parameterName As String, _
	sqlDbType As SqlDbType _
) As SqlParameter


Type: System.String

The name of the parameter.

Type: System.Data.SqlDbType

One of the SqlDbType values.

Return Value

Type: System.Data.SqlClient.SqlParameter
A new SqlParameter object.

Public Sub AddSqlParameter(command As SqlCommand) 
  Dim param As SqlParameter = command.Parameters.Add( _
      "@Description", SqlDbType.NVarChar)
  param.Size = 16
  param.Value = "Beverages" 
End Sub

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
© 2015 Microsoft