try this
string where = "";
foreach (object item in checkedListBox1.CheckedItems)
where += string.Format("'{0}',", item);
where = where.TrimEnd(',');
string query = "select * from Final where Assigrp in ({0})";
string s = string.Format(query, where);
sda = new SqlDataAdapter(s, con);