SqlParameter Constructor(String,Object)

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal parameterName As String, _
   ByVal value As Object _
)

public SqlParameter( 
   string parameterName,
   object value
)

Parameters

parameterName: The name of the parameter.
value: An Object that is the value of the SqlParameter.

Example

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

csharp

public void CreateSqlParameter() 
{
        SqlParameter myParameter = new SqlParameter("DName", "e.g.: some string value");
        myParameter.Direction = ParameterDirection.Input;
}

Visual Basic

Public Sub CreateSqlParameter()
        Dim myParameter As New SqlParameter("DName", "e.g.: some string value")
        myParameter.Direction = ParameterDirection.Input
End Sub 'CreateSqlParameter

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback