Add(String,SqlType) Method

On this page

Adds a SqlParameter to the SqlParameterCollection given the parameter name and data type.

Syntax

Visual Basic
C#


'Declaration Public Overloads Function Add( _ ByVal parameterName As String, _ ByVal type As SqlType _ ) As SqlParameter


public SqlParameter Add( string parameterName, SqlType type )

Parameters

parameterName: The name of the parameter.
type: One of the SqlType values.

Return Value

The new SqlParameter object.

Example

The following example creates a SqlParameterCollection, adds instances of SqlParameter to the collection, and returns a reference to the new SqlParameter.

csharp


public void CreateSqlParamColl(SqlConnection myConn) { SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn); SqlParameterCollection myParamCollection = myCommand.Parameters; object myParm = new SqlParameter("DeptNo", SqlType.Int); int pIndex = myParamCollection.Add(myParm); }

public void CreateSqlParamColl(SqlConnection myConn) {
  SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
  SqlParameterCollection myParamCollection = myCommand.Parameters;
  object myParm = new SqlParameter("DeptNo", SqlType.Int);
  int pIndex = myParamCollection.Add(myParm);
}

Visual Basic


Public Sub CreateSqlParamColl(myConn As SqlConnection) Dim myCommand As SqlCommand = New SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn) Dim myParamCollection As SqlParameterCollection = myCommand.Parameters Dim myParm As Object = New SqlParameter("DeptNo", SqlType.Int) Dim pIndex As Integer = myParamCollection.Add(myParm) End Sub

Public Sub CreateSqlParamColl(myConn As SqlConnection)
  Dim myCommand As SqlCommand = New SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn)
  Dim myParamCollection As SqlParameterCollection = myCommand.Parameters
  Dim myParm As Object = New SqlParameter("DeptNo", SqlType.Int)
  Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub

Reference

SqlParameterCollection Class
SqlParameterCollection Members
Overload List

Send Feedback