bipolar

private void populate_to ()
{
	Gtk.ListStore cb_to_model = new Gtk.ListStore (typeof(string), typeof(string));
	//cb_to is a Gtk.ComboBox
	cb_to.Model = cb_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)
	{
		Console.WriteLine(row["Name"].ToString() + "::" + row["ID"].ToString());
		cb_to_model.AppendValues(row["Name"].ToString(),row["ID"].ToString());

	}
	
	Gtk.CellRendererText nameCell = new Gtk.CellRendererText ();
	cb_to.PackStart (nameCell,true);
	cb_to.AddAttribute (nameCell, "text", 0);

}