string s=DropDownList1.SelectedValue;foreach (CheckBox c in CheckBoxList1.Items){ if (c.Checked) s += "," + c.Text;}cmd.CommandText = "SELECT ....... tsr in ("+s+") ORDER BY.....";
