SqlParameter Constructor()

In This Topic

Initializes a new instance of the SqlParameter class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New()

public SqlParameter()

Remarks

The base constructor initializes all fields to their default values.

Example

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

csharp

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

Visual Basic

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

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback