ParameterCollection.Insert(Int32, Parameter) Method

Reference

Definition

Namespace:: System.Web.UI.WebControls

Assembly:: System.Web.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

ArgumentOutOfRangeException

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

Share via