Export (0) Print
Expand All

ParameterCollection.Add Method (String, TypeCode, String)

Creates a Parameter object with the specified name, TypeCode, and default value, and appends it to the end of the collection.

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

public int Add(
	string name,
	TypeCode type,
	string value
)

Parameters

name
Type: System.String

The name of the parameter.

type
Type: System.TypeCode

The type of the parameter.

value
Type: System.String

The default value for the parameter.

Return Value

Type: System.Int32
The index value of the added item.

Use the Add(String, TypeCode, String) method to create and append a strongly typed Parameter object with a default value to the end of the collection. This implementation of the method creates the Parameter object using the name, type and value specified by the name, type and value parameters, respectively, and appends it to the collection.

The following code example demonstrates how the Add(String, TypeCode, String) method can be used to add new Parameter objects to a ParameterCollection collection by supplying the name, value, and type parameters. In this example, a Parameter object is added to an Update command of an Access data source control that provides the value of the current system time. The parameter is added with the TypeCode of DateTime.

<script runat="server">
private void UpdateRecords(Object source, EventArgs e)
{
  CheckBox cb;
  foreach(GridViewRow row in this.GridView1.Rows) {
    cb = (CheckBox) row.Cells[0].Controls[1];
    if(cb.Checked) {
      string oid = (string) row.Cells[1].Text;
      MyAccessDataSource.UpdateParameters.Add("date", TypeCode.DateTime, DateTime.Now.ToString());
      MyAccessDataSource.UpdateParameters.Add("orderid", oid);
      MyAccessDataSource.Update();
      MyAccessDataSource.UpdateParameters.Clear();
    }
  }
}
</script>

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft