ParameterCollection.Insert(Int32, Parameter) Method
Definition
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
Exceptions
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
.NET