ControlParameter Constructor (String, String, String)
Assembly: System.Web (in system.web.dll)
public ControlParameter ( String name, String controlID, String propertyName )
public function ControlParameter ( name : String, controlID : String, propertyName : String )
Parameters
- name
The name of the parameter.
- controlID
The name of the control that the parameter is bound to. The default is Empty.
- propertyName
The name of the property on the control that the parameter is bound to. The default is Empty.
A ControlParameter object created with the ControlParameter constructor is initialized with the specified parameter name, Control name, and PropertyName property, which identifies the Control that the parameter binds to. Other properties, including Type, Direction, and ConvertEmptyStringToNull, are initialized with default values.
The following code example demonstrates how to create ControlParameter objects using the ControlParameter constructor. The parameters bind to the values of TextBox and DropDownList controls to enter data in a database from a Web Forms page.
private void Button1_Click(Object sender, System.EventArgs e)
{
// The user has pressed the Submit button, prepare a parameterized
// SQL query to insert the values from the controls.
AccessDataSource1.set_InsertCommand("INSERT INTO Employees"
+ "(FirstName,LastName,Address,City,PostalCode,Country,ReportsTo) "
+ " VALUES (?,?,?,?,?,?,? ); ");
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("FirstName", "TextBox1", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("LastName", "TextBox2", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("Address", "TextBox3", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("City", "TextBox4", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("PostalCode", "TextBox5", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("Country", "TextBox6", "Text"));
AccessDataSource1.get_InsertParameters().Add(new ControlParameter
("ReportsTo", "DropDownList1", "SelectedValue"));
try {
AccessDataSource1.Insert();
}
finally {
Button1.set_Visible(false);
Label9.set_Visible(true);
}
} //Button1_Click
Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.