ParameterCollection.Insert(Int32, Parameter) Method

Definition

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

public:
 void Insert(int index, System::Web::UI::WebControls::Parameter ^ parameter);
public void Insert (int index, System.Web.UI.WebControls.Parameter parameter);
member this.Insert : int * System.Web.UI.WebControls.Parameter -> unit
Public Sub Insert (index As Integer, parameter As Parameter)

Parameters

index
Int32

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

parameter
Parameter

The Parameter to insert.

Exceptions

index is less than zero.

-or-

index is greater than Count.

Examples

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");
    aSqlDataSource.SelectParameters.Add(qs1);

    QueryStringParameter qs3 =
        new QueryStringParameter("QueryStringParam3","requestfield3");
    aSqlDataSource.SelectParameters.Add(qs3);

    // 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>");
    }
}
</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 qs3 As New QueryStringParameter("QueryStringParam3","requestfield3")
    aSqlDataSource.SelectParameters.Add(qs3)

    Dim qs2 As New QueryStringParameter("QueryStringParam2","requestField2")
    ' Insert
    aSqlDataSource.SelectParameters.Insert(1, qs2)

    ' 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>")
    Next
End Sub ' Page_Load
</SCRIPT>

Applies to

See also