There are several ways to do this.
Using SQL
If you are using SQL in your database for example could you not do a
select * from emails where (not (email is null))
Using Dataset
If you are binding directly to a datatable (from a dataset) set then you could use a dataview or linq expression.
Linq
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
FillDataSet(ds);
DataTable emails= ds.Tables["Emails"];
var query =
from email in emails.AsEnumerable()
where order.Field<string>("EmailAddress") != ""
select new
{
EmailAddress = order.Field<string>("EmailAddress")
};
chkBoxList.DataSource = query.ToList;
chkBoxList.DataBind();
DataView
DataView emailsView = new DataView(emailsDS.Tables["Emails"],
"EmailAddress <> ''",
"EmailAddress",
DataViewRowState.CurrentRows);
chkBoxList.DataSource = emailsView;
chkBoxList.DataBind();