This documentation is archived and is not being maintained.

LinqDataSourceSelectEventArgs.WhereParameters Property

Gets the collection of parameters that is used to create the Where clause.

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

public IDictionary<string, Object> WhereParameters { get; }

Property Value

Type: System.Collections.Generic.IDictionary<String, Object>
An object that contains the parameters for the Where clause.

You use the WhereParameters property to access parameters for the Where clause in a handler for the Selecting event. You can modify the Where clause by adding or removing parameters from this collection. By default, the WhereParameters property of the LinqDataSourceSelectEventArgs object contains any parameters that you added to the WhereParameters of the LinqDataSource control.

When you add parameters through the WhereParameters collection of the LinqDataSourceSelectEventArgs object, you must either include a placeholder for the parameter in the Where property or set the AutoGenerateWhereClause property to true. For example, if you add a parameter named ProductName in the event handler for the Selecting event, you must either set the AutoGenerateWhereClause property to true or set the Where property to ProductName=@ProductName.

The following example shows how to add a parameter to the WhereParameters collection. The added parameter will limit the returned products to only those products with a value of "Bike" in the Name property. The AutoGenerateWhereClause property is set to true so that the parameter is automatically included in the Where clause.

<script runat="server">
    protected void LinqDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
        e.WhereParameters.Add("Name", "Bike");

<html xmlns="">
<head runat="server">
    <title>Example Page</title>
    <form id="form1" runat="server">

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5