private void waitAndLoad() { string q = ""; if (deviceBuilding == "") { q = "SELECT * FROM employee"; } else { q = "SELECT * FROM employee WHERE building_id='" + deviceBuilding.Substring(0, 3) + "'"; } dt = oc.query(q); attendanceTable = oc.query("SELECT * FROM attendance ORDER BY work_date"); //MessageBox.Show("Query: " + q); }
private void WaitAndLoad() { string q = "SELECT * FROM holidays"; dt = oc.query(q); }