string clr = "";int x=0;
for (int i = 0; i < chklst_color.Items.Count; i++)
{
if (chklst_color.Items[i].Selected ==true)
{
x = 1;
clr = clr + "'" + chklst_color.Items[i].Text + "',";
}
}
if(x==1)
{
clr = clr .TrimEnd(',');
query="select sarees from table where color in ('"+clr +"' )";
}
if it helps please mark as answer ......