ParameterCollection.Add Method (String, String)

 

Creates a Parameter object with the specified name 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 Function Add (
	name As String,
	value As String
) As Integer

Parameters

name
Type: System.String

The name of the parameter.

value
Type: System.String

A string that serves as a default value for the parameter.

Return Value

Type: System.Int32

The index value of the added item.

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

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

System_CAPS_security Security 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.

<script runat="server">
Private Sub UpdateRecords(source As Object, e As EventArgs)

  Dim cb As CheckBox
  Dim row As GridViewRow

  For Each row In GridView1.Rows

    cb = CType(row.Cells(0).Controls(1), CheckBox)
    If cb.Checked Then

      Dim oid As String
      oid = CType(row.Cells(1).Text, String)

      MyAccessDataSource.UpdateParameters.Add("date", TypeCode.DateTime, DateTime.Now.ToString())

      MyAccessDataSource.UpdateParameters.Add("orderid", oid)

      MyAccessDataSource.Update()
      MyAccessDataSource.UpdateParameters.Clear()
    End If
  Next
End Sub ' UpdateRecords
</script>

.NET Framework
Available since 2.0
Return to top
Show: