i am using IN with Where parameter in Entitydatasource.
if i Writing this, it complete return Men, Unisex. value.
<asp:EntityDataSource ID="EntityDataSource_Pendant" runat="server"
EnableFlattening="False"
ConnectionString="name=MyEntities"
DefaultContainerName="MyEntities"
EntitySetName="Pendants"
AutoGenerateWhereClause="False"
AutoGenerateOrderByClause="True"
Where="it.Gender IN {'Men','Unisex'}"
onselected="EntityDataSource_Pendant_Selected" >
<WhereParameters>
<asp:Parameter Name="Gender" Type="String"/>
</WhereParameters>
-----------------------------------------
but if i Write this, it cant return any data.....
<asp:EntityDataSource ID="EntityDataSource_Pendant" runat="server"
EnableFlattening="False"
ConnectionString="name=MyEntities"
DefaultContainerName="MyEntities"
EntitySetName="Pendants"
AutoGenerateWhereClause="False"
AutoGenerateOrderByClause="True"
Where="it.Gender IN {@Gender}"
onselected="EntityDataSource_Pendant_Selected" >
<WhereParameters>
<asp:Parameter Name="Gender" Type="String" DefaultValue="'Men','Unisex'"/>
</WhereParameters>
also it cant set return from CodeBehind..
--------------------------
EntityDataSource_Pendant.WhereParameters["Gender"].DefaultValue = "'Men','Unisex'";
-----------------------------
i also refer below link, but i cant get solution.