hi guys,
in below code "it.CategoryId_FK" is integer and "InStatement" is string, so how can i fix it?
protected void EntityDataSource_Selecting(object sender, EntityDataSourceSelectingEventArgs e)
{
List<int> IDsList = new List<int>() { 1, 2, 3, 4 };
string InStatement = IDsList.Count > 0 ? "(" : string.Empty;
foreach (int id in IDsList)
{
InStatement += id.ToString() + ",";
}
if (IDsList.Count > 0)
{
//remove the last ","
InStatement = InStatement.Substring(0, InStatement.Length - 1);
InStatement += ")";
}
EntityDataSource1.Where = "(it.CategoryId_FK=@Cat||it.CategoryId_FK In " + InStatement + ") and (it.Language= @lang||@lang=@All)and(i ...
Go to the complete details ...