query = "SELECT DISTINCT number FROM tableName ";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
CheckBoxList1.DataSource = ds;
CheckBoxList1.DataTextField = "number";
...
Go to the complete details ...