Item Property (PgSqlParameterCollection)
The following example creates a
PgSqlParameterCollection, adds instances of
PgSqlParameter to the collection, displays the names of its
PgSqlParameter objects, and then clears the collection.
public void CreatePgSqlParamColl(PgSqlCommand pgCommand) {
PgSqlParameterCollection myParamCollection = pgCommand.Parameters;
myParamCollection.Add("DeptNo", PgSqlType.Integer);
myParamCollection.Add("DName", PgSqlType.VarChar);
myParamCollection.Add("Loc", PgSqlType.VarChar);
string myParamNames = "";
for (int i=0; i < myParamCollection.Count; i++)
myParamNames += myParamCollection[i].ToString() + "\n";
MessageBox.Show(myParamNames);
myParamCollection.Clear();
}
Public Sub CreatePgSqlParamColl(pgCommand As PgSqlCommand)
Dim myParamCollection As PgSqlParameterCollection = pgCommand.Parameters
myParamCollection.Add("DeptNo", PgSqlType.Integer)
myParamCollection.Add("DName", PgSqlType.VarChar)
myParamCollection.Add("Loc", PgSqlType.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