SqlParameter Constructor(String,SqlType,Int32)

In This Topic

Initializes a new instance of the SqlParameter class with the parameter name, data type, and width.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal parameterName As String, _
   ByVal dbType As SqlType, _
   ByVal size As Integer _
)

public SqlParameter( 
   string parameterName,
   SqlType dbType,
   int size
)

Parameters

parameterName: The name of the parameter.
dbType
size: The maximum size, in bytes, of the data within the column.

Example

The following example creates a new SqlParameter and sets some of its properties.

csharp

public void CreateSqlParameter()
{
  SqlParameter myParameter = new SqlParameter("DName", SqlType.VarChar, 15);
  myParameter.Direction = ParameterDirection.Input;
}

Visual Basic

Public Sub CreateSqlParameter()
    Dim myParameter As New SqlParameter("DName", SqlType.VarChar, 15)
    myParameter.Direction = ParameterDirection.Input
End Sub

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback