ControlFilterExpression.Column Property

Definition

Namespace:

System.Web.DynamicData

Assembly:

System.Web.DynamicData.dll

Gets or sets the name of the column that the query is based on.

public:
 property System::String ^ Column { System::String ^ get(); void set(System::String ^ value); };

public string Column { get; set; }

member this.Column : string with get, set

Public Property Column As String

Property Value

String

The name of the column that the query is based on.

Examples

The following example shows how to use the ControlFilterExpression class to set the column that the filter applies to.

<asp:QueryExtender ID="QueryExtenderID"   
    TargetControlID="TargetDataSourceID" runat="server">  
    <asp:ControlFilterExpression ControlID="GridViewID" Column="Category"/>  
</asp:QueryExtender>  

Remarks

If this property is empty, the ControlFilterExpression control treats the selected data key as the primary key of the current table. This is useful in a list-details scenario where source and target data-bound controls operate on data from the same table.

If you assign a value to the property, the ControlFilterExpression control treats the data key as a foreign key. The value assigned to this property becomes the name of the column that is displayed in the target data-bound control. This is useful in a parent-child scenario where the target data-bound control operates on data from the child table and the source data-bound control operates on data from the parent table.