ParameterCollection.Insert Method

Inserts the specified Parameter object into the ParameterCollection collection at the specified index.

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)

public void Insert (
	int index,
	Parameter parameter
public void Insert (
	int index, 
	Parameter parameter
public function Insert (
	index : int, 
	parameter : Parameter
Not applicable.



The zero-based index at which the Parameter is inserted.


The Parameter to insert.

Exception typeCondition


index is less than zero.


index is greater than Count.

The following code example demonstrates how to use the Insert method to add a Parameter object to a ParameterCollection collection at a specific location. In this example, several QueryStringParameter objects are added to a SelectParameters collection, one QueryStringParameter is inserted into the collection, and the order of the collection is printed when the page loads.

<%@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");

    QueryStringParameter qs3 =
        new QueryStringParameter("QueryStringParam3","requestfield3");

    // Insert
    aSqlDataSource.SelectParameters.Insert(1, new QueryStringParameter("QueryStringParam2", "requestField2") );

    // 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>");

<%@page Language="VJ#" %>
<SCRIPT runat="server">
private void Page_Load(Object sender,System.EventArgs e) 
    SqlDataSource aSqlDataSource = new SqlDataSource();
    QueryStringParameter qs1 = new QueryStringParameter("QueryStringParam1", 


    QueryStringParameter qs3 = new QueryStringParameter("QueryStringParam3", 


    // Insert            
    aSqlDataSource.get_SelectParameters().Insert(1, new QueryStringParameter(
        "QueryStringParam2", "requestField2"));

    // Iterate through the ParameterCollection and print out the 
    // names of the Parameters contained by it.
    Parameter aParameter = null;
    for (int iCtr = 0; iCtr < aSqlDataSource.get_SelectParameters()
        .get_Count();iCtr++) {
            aParameter = aSqlDataSource.get_SelectParameters().get_Item(iCtr);
            get_Response().Write(aParameter.get_Name() + "<BR>");
} //Page_Load

Windows 98, Windows Server 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions