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)

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

Parameters

parameterName
Type: System.String

The name of the parameter.

sqlDbType
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
Show:
© 2015 Microsoft