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.
Assembly: System.Web (in System.Web.dll)
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.
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.
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>
Available since 2.0
