LinqDataSourceSelectEventArgs.WhereParameters Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the collection of parameters that is used to create the Where clause.
public:
property System::Collections::Generic::IDictionary<System::String ^, System::Object ^> ^ WhereParameters { System::Collections::Generic::IDictionary<System::String ^, System::Object ^> ^ get(); };
public System.Collections.Generic.IDictionary<string,object> WhereParameters { get; }
member this.WhereParameters : System.Collections.Generic.IDictionary<string, obj>
Public ReadOnly Property WhereParameters As IDictionary(Of String, Object)
Property Value
An object that contains the parameters for the Where clause.
Examples
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");
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Example Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:LinqDataSource
ContextTypeName="ExampleDataContext"
TableName="Products"
AutoGenerateWhereClause="true"
OnSelecting="LinqDataSource_Selecting"
ID="LinqDataSource1"
runat="server">
</asp:LinqDataSource>
<asp:GridView
DataSourceID="LinqDataSource1"
ID="GridView1"
runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
<script runat="server">
Protected Sub LinqDataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.LinqDataSourceSelectEventArgs)
e.WhereParameters.Add("Name", "Bike")
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Example Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:LinqDataSource
ContextTypeName="ExampleDataContext"
TableName="Products"
AutoGenerateWhereClause="true"
OnSelecting="LinqDataSource_Selecting"
ID="LinqDataSource1"
runat="server">
</asp:LinqDataSource>
<asp:GridView
DataSourceID="LinqDataSource1"
ID="GridView1"
runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
Remarks
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
.
Applies to
See also
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru