SqlParameter Constructor(String,SqlType)

In This Topic

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

Syntax

Visual Basic
C#

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

public SqlParameter( 
   string parameterName,
   SqlType dbType
)

Parameters

parameterName: The name of the parameter.
dbType

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);
  myParameter.Direction = ParameterDirection.Input;
  myParameter.Size = 15;
}

Visual Basic

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

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback