ParameterCollection.Add Method (Parameter)

Appends the specified Parameter object to the end of the collection.

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

public:
int Add (
	Parameter^ parameter
)
public int Add (
	Parameter parameter
)
public function Add (
	parameter : Parameter
) : int
Not applicable.

Parameters

parameter

The Parameter to append to the collection.

Return Value

The index value of the added item.

Use the Add(Parameter) method to append a Parameter object to the end of the collection. This implementation of the method takes the Parameter object specified by the param parameter and appends it to the collection.

The following code example demonstrates how to use an AccessDataSource control and a FormParameter object to display information from a Microsoft Access database in a GridView control. The FormParameter object is added to the SelectParameters collection using the Add(Parameter) method.

Security noteSecurity Note:

This example has a text box that accepts user input, which is a potential security threat. By default, ASP.NET Web pages validate that user input does not include script or HTML elements. For more information, see Script Exploits Overview (Visual Studio).

No code example is currently available or this language may not be supported.
<%@Page Language="VJ#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    void Page_Load(Object sender, System.EventArgs e)
    {
        // You can add a FormParameter to the AccessDataSource control's
        // SelectParameters collection programmatically.
        AccessDataSource1.get_SelectParameters().Clear();

        FormParameter formParam = new FormParameter("lastname", "LastNameBox");

        formParam.set_Type(System.TypeCode.String);
        AccessDataSource1.get_SelectParameters().Add(formParam);
    } //Page_Load
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
  <head runat="server">
    <title>ASP.NET Example</title>
</head>
<body>
    <form id="Form1" runat="server">

      <asp:accessdatasource
          id="AccessDataSource1"
          runat="server"
          datasourcemode="DataSet"
          datafile="Northwind.mdb"
          selectcommand="SELECT OrderID,CustomerID,OrderDate,RequiredDate,ShippedDate
          FROM Orders WHERE EmployeeID = (SELECT EmployeeID FROM Employees WHERE LastName = @lastname)">
      </asp:accessdatasource>

      <br />Enter the name "Davolio" or "King" in the text box and click the button.

      <br />
      <asp:textbox
        id="LastNameBox"
        runat="server" />

      <br />
      <asp:button
        id="Button1"
        runat="server"
        text="Get Records" />

      <br />
      <asp:gridview
          id="GridView1"
          runat="server"
          allowsorting="True"
          datasourceid="AccessDataSource1">
      </asp:gridview>

    </form>
  </body>
</html>

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

ADD
Show: