Export (0) Print
Expand All

ControlParameter Constructor (String, String, String)

Initializes a new named instance of the ControlParameter class, using the specified property name and control name to identify which control to bind to.

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

public ControlParameter(
	string name,
	string controlID,
	string propertyName
)

Parameters

name
Type: System.String

The name of the parameter.

controlID
Type: System.String

The name of the control that the parameter is bound to. The default is String.Empty.

propertyName
Type: System.String

The name of the property on the control that the parameter is bound to. The default is String.Empty.

A ControlParameter object that is 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 shows how to create ControlParameter objects by 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, EventArgs e) {

    // The user has pressed the Submit button, prepare a parameterized
    // SQL query to insert the values from the controls.
    AccessDataSource1.InsertCommand =
    "INSERT INTO Employees (FirstName,LastName,Address,City,PostalCode,Country,ReportsTo) " +
    "  VALUES (?,?,?,?,?,?,? ); ";

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("FirstName", "TextBox1", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("LastName", "TextBox2", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("Address", "TextBox3", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("City", "TextBox4", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("PostalCode", "TextBox5", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("Country", "TextBox6", "Text"));

    AccessDataSource1.InsertParameters.Add(
      new ControlParameter("ReportsTo", "DropDownList1", "SelectedValue"));

    try {
        AccessDataSource1.Insert();
    }
    finally {
        Button1.Visible = false;
        Label9.Visible = true;
    }
}

.NET Framework

Supported in: 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