SqlParameter Constructor()

In This Topic

Syntax
Remarks
Example
Requirements
See Also

Initializes a new instance of the SqlParameter class.

Syntax

Visual Basic
C#

public SqlParameter()

'Declaration
 
Public Function New()

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlParameter Class
SqlParameter Members
Overload List

Send Feedback