public static void CheckCheckListBox(DevExpress.XtraEditors.CheckedListBoxControl checkListBox, string tableName, string fieldName, string whereStr)
{
int i = 0;
while (i < checkListBox.ItemCount)
{
checkListBox.SetItemCheckState(i, ((Services.Database.SelectFieldValue(tableName, fieldName, whereStr + checkListBox.GetItemValue(i).ToString() + "'") != null) ? CheckState.Checked : CheckState.Unchecked));
i = i + 1;
}
}