Item(Int32) Property

In This Topic

Gets or sets the SqlParameter at the specified index.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Property Item( _
   ByVal index As Integer _
) As SqlParameter

public new SqlParameter Item( 
   int index
) {get; set;}

Parameters

index: The zero-based index of the parameter to retrieve.

Property Value

The SqlParameter at the specified index.

Example

The following example creates a SqlParameterCollection, adds instances of SqlParameter to the collection, displays the names of its SqlParameter objects, and then clears the collection.

csharp

public void CreateSqlParamColl(SqlCommand myCommand) {
  SqlParameterCollection myParamCollection = myCommand.Parameters;
  myParamCollection.Add("DeptNo", SqlType.Integer);
  myParamCollection.Add("DName", SqlType.VarChar);
  myParamCollection.Add("Loc", SqlType.VarChar);
  string myParamNames = "";
  for (int i=0; i < myParamCollection.Count; i++)
    myParamNames += myParamCollection[i].ToString() + "\n";
  MessageBox.Show(myParamNames);
  myParamCollection.Clear();
}

Visual Basic

Public Sub CreateSqlParamColl(myCommand As SqlCommand)
  Dim myParamCollection As SqlParameterCollection = myCommand.Parameters
  myParamCollection.Add("DeptNo", SqlType.Integer)
  myParamCollection.Add("DName", SqlType.VarChar)
  myParamCollection.Add("Loc", SqlType.VarChar)
  Dim myParamNames As String = ""
  Dim i As Integer
  For i = 0 To myParamCollection.Count - 1
    myParamNames += myParamCollection(i).ToString() + ControlChars.Cr
  Next i
  MessageBox.Show(myParamNames)
  myParamCollection.Clear()
End Sub

Reference

SqlParameterCollection Class
SqlParameterCollection Members
Overload List

Send Feedback