Add(String,SqlType) Method
Adds a
SqlParameter to the
SqlParameterCollection given the parameter name and data type.
The following example creates a
SqlParameterCollection, adds instances of
SqlParameter to the collection, and returns a reference to the new
SqlParameter.
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 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
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