System.Data.SqlClient Namespace   SqlParameter Class

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

[ VB ]
Overloads Public Sub New ( _
   ByVal name As String, _
   ByVal dataType As SqlDbType _
)

[ C# ]
public SqlParameter (
   string name,
   SqlDbType dataType
);

[ C++ ]
public: SqlParameter (
   String* name,
   SqlDbType dataType
);

[ JScript ]
public function SqlParameter (
   name : String,
   dataType : SqlDbType
);

name

The name of the parameter to map.

dataType

One of the SqlDbType values.

The Size and Precision are inferred from the SqlDbType parameter.

The following example initializes an SqlParameter using this constructor and sets some of its properties.

public void CreateSqlParameter ( ) {
   SqlParameter myParam = new SqlParameter ( "@Description", SqlDbType.VarChar );
   myParam.Direction = ParameterDirection.Output;
}

Public Sub CreateSqlParameter ( )
   Dim myParam As New SqlParameter ( "@Description", SqlDbType.VarChar )
   myParam.Direction = ParameterDirection.Output
End Sub

SqlParameter Members   SqlParameter Constructor Overload List