SqlParameter Constructor(String,SqlType,Int32,String)

In This Topic

Initializes a new instance of the SqlParameter class with the parameter name, data type, width, and source column name. For internal use.

Syntax

Visual Basic
C#

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

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

Parameters

parameterName: The name of the parameter.
dbType
size: The maximum size, in bytes, of the data within the column.
sourceColumn: The name of the source 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, "DName");
  myParameter.Direction = ParameterDirection.Input;
}

Visual Basic

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

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback