bipolar

private void populate_to ()
{
	Gtk.ListStore cbe_to_model = new Gtk.ListStore (typeof(string), typeof(string));
	//cbe_to is a Gtk.ComboBoxEntry
	cbe_to.Model = cbe_to_model;
	
	string query = "SELECT Employee_Number AS \"ID\", IF(Suffix is null,"
					+ "CONCAT(First_Name, \" \", Last_Name),CONCAT"
					+ "(First_Name, \" \", Last_Name, \", \", Suffix)) "
					+ "AS \"Name\" FROM tbl_employees WHERE "
					+ "Gets_Issues = -1 AND Fire_Date IS Null";

	DataSet ds = ((cl_getdata)cl_Vars.cl_getdata).returndataset(query);
    DataTable table = ds.Tables[0];
    foreach (DataRow row in table.Rows)
    {
    	cbe_to_model.AppendValues(row["ID"].ToString(),row["Name"].ToString());
    }
}