Sheritlw
asked on
Change value of where parameter
I have a gridview with a linqdatasource.
In the footer of the gridview I have a checkbox. When a user clicks the checkbox, I need to set my where clause to active = false otherwise active = true.
I can get the checkbox in code behind so I will probably need to change it in the checkbox textchanged event.
How would I do this?
Thanks
In the footer of the gridview I have a checkbox. When a user clicks the checkbox, I need to set my where clause to active = false otherwise active = true.
I can get the checkbox in code behind so I will probably need to change it in the checkbox textchanged event.
How would I do this?
Thanks
<asp:LinqDataSource ID="lnqClientList" runat="server"
ContextTypeName="Service2020.SalonDataClassesDataContext" TableName="Clients"
Where="UserID == @UserID && Active == @Active"
EnableDelete="True" OrderBy="FullName, LastServiceDate desc">
<WhereParameters>
<asp:SessionParameter DbType="Guid" Name="UserID" SessionField="UserID" />
<asp:Parameter DefaultValue="true" Name="Active" Type="Boolean" />
</WhereParameters>
</asp:LinqDataSource>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER