ParameterCollection.RemoveAt Method
.NET Framework 3.0
Removes the Parameter object at the specified index from the ParameterCollection collection.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)
Assembly: System.Web (in system.web.dll)
The following code example demonstrates how to use the RemoveAt method to remove a Parameter object from a ParameterCollection collection at a specific location. In this example, several QueryStringParameter objects are added to a SelectParameters collection, one QueryStringParameter object is removed from the collection, and the order of the collection is printed when the page loads.
<%@page Language="VJ#" %>
<SCRIPT runat="server">
private void Page_Load(Object sender, System.EventArgs e)
{
SqlDataSource aSqlDataSource = new SqlDataSource();
QueryStringParameter qs1 =
new QueryStringParameter("QueryStringParam1","requestfield1");
aSqlDataSource.get_SelectParameters().Add(qs1);
QueryStringParameter qs3 =
new QueryStringParameter("QueryStringParam2","requestfield2");
aSqlDataSource.get_SelectParameters().Add(qs3);
// Insert another QueryStringParameter with the same name as the previous
// parameter.
aSqlDataSource.get_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.get_SelectParameters().RemoveAt(
(aSqlDataSource.get_SelectParameters().get_Count() - 1) );
// Iterate through the ParameterCollection and print out the
// names of the Parameters contained by it.
for(int iCtr =0; iCtr < aSqlDataSource.get_SelectParameters().
get_Count(); iCtr++) {
Parameter aParameter = aSqlDataSource.get_SelectParameters().
get_Item(iCtr);
get_Response().Write(aParameter.get_Name() + "<BR>");
QueryStringParameter qsptemp = (QueryStringParameter) aParameter;
get_Response().Write("QueryStringField is "
+ qsptemp.get_QueryStringField() + "<BR>");
}
} //Page_Load
</SCRIPT>
Community Additions
ADD
Show: