ParameterCollection.Add Method (String, String)
Assembly: System.Web (in system.web.dll)
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 (Visual Studio). |
<script runat="server">
private void UpdateRecords(Object source, System.EventArgs e)
{
CheckBox cb;
for (int iCtr = 0; iCtr < this.GridView1.get_Rows().get_Count(); iCtr++) {
GridViewRow row = this.GridView1.get_Rows().get_Item(iCtr);
cb = (CheckBox)row.get_Cells().get_Item(0).get_Controls().
get_Item(1);
if (cb.get_Checked()) {
String oid = (String)(row.get_Cells().get_Item(1).get_Text());
MyAccessDataSource.get_UpdateParameters().Add(
"date", System.TypeCode.DateTime,
System.DateTime.get_Now().toString());
MyAccessDataSource.get_UpdateParameters().Add("orderid", oid);
MyAccessDataSource.Update();
MyAccessDataSource.get_UpdateParameters().Clear();
}
}
} //UpdateRecords
</script>
Security Note: