ParameterCollection.RemoveAt(Int32) Méthode
Définition
Important
Certaines informations portent sur la préversion du produit qui est susceptible d’être en grande partie modifiée avant sa publication. Microsoft exclut toute garantie, expresse ou implicite, concernant les informations fournies ici.
Supprime l'objet Parameter de la collection ParameterCollection à l'index spécifié.
public:
void RemoveAt(int index);
public void RemoveAt (int index);
member this.RemoveAt : int -> unit
Public Sub RemoveAt (index As Integer)
Paramètres
Exemples
L’exemple de code suivant montre comment utiliser la RemoveAt méthode pour supprimer un Parameter objet d’une collection à un ParameterCollection emplacement spécifique. Dans cet exemple, plusieurs QueryStringParameter objets sont ajoutés à une SelectParameters collection, un QueryStringParameter objet est supprimé de la collection et l’ordre de la collection est imprimé lors du chargement de la page.
<%@page Language="C#" %>
<SCRIPT runat="server">
private void Page_Load(object sender, EventArgs e) {
SqlDataSource aSqlDataSource = new SqlDataSource();
// Security Note: The SqlDataSource uses a QueryStringParameter,
// Security Note: which does not perform validation of input from the client.
QueryStringParameter qs1 =
new QueryStringParameter("QueryStringParam1","requestfield1");
aSqlDataSource.SelectParameters.Add(qs1);
QueryStringParameter qs3 =
new QueryStringParameter("QueryStringParam2","requestfield2");
aSqlDataSource.SelectParameters.Add(qs3);
// Insert another QueryStringParameter with the same name as the previous parameter.
aSqlDataSource.SelectParameters.Add( new QueryStringParameter("QueryStringParameter2","requestfield3") );
// There are two parameters named QueryStringParam3. Use the
// RemoveAt method to remove the last element from the collection.
aSqlDataSource.SelectParameters.RemoveAt( (aSqlDataSource.SelectParameters.Count - 1) );
// Iterate through the ParameterCollection and print out the
// names of the Parameters contained by it.
foreach (Parameter aParameter in aSqlDataSource.SelectParameters) {
Response.Write(aParameter.Name + "<BR>");
QueryStringParameter qsptemp = (QueryStringParameter) aParameter;
Response.Write("QueryStringField is " + qsptemp.QueryStringField + "<BR>");
}
}
</SCRIPT>
<%@page Language="VB" %>
<SCRIPT runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim aSqlDataSource As New SqlDataSource()
' Security Note: The SqlDataSource uses a QueryStringParameter,
' Security Note: which does not perform validation of input from the client.
Dim qs1 As New QueryStringParameter("QueryStringParam1","requestfield1")
aSqlDataSource.SelectParameters.Add(qs1)
Dim qs2 As New QueryStringParameter("QueryStringParam2","requestfield2")
aSqlDataSource.SelectParameters.Add(qs2)
' Insert another QueryStringParameter with the same name as the previous parameter.
Dim qs3 As New QueryStringParameter("QueryStringParam2","requestfield3")
aSqlDataSource.SelectParameters.Add(qs3)
' There are two parameters named QueryStringParam3. Use the
' RemoveAt method to remove the last element from the collection.
aSqlDataSource.SelectParameters.RemoveAt( (aSqlDataSource.SelectParameters.Count - 1) )
' Iterate through the ParameterCollection and print out the
' names of the Parameters contained by it.
Dim aParameter As Parameter
For Each aParameter in aSqlDataSource.SelectParameters
Response.Write(aParameter.Name & "<BR>")
Dim qsptemp As QueryStringParameter = CType(aParameter, QueryStringParameter)
Response.Write("QueryStringField is " & qsptemp.QueryStringField & "<BR>")
Next
End Sub ' Page_Load
</SCRIPT>
Remarques
Utilisez la RemoveAt méthode pour supprimer l’objet Parameter à l’index spécifié de la collection.