private void LoadTickets() { DataTable dt = DataAccess.GetData("SELECT TicketID, DepartureAirport + ' - ' + ArrivalAirport + ' (' + CONVERT(VARCHAR(MAX), DepartureTime) + ')'AS TicketInfo FROM Ticket"); UIUtilities.FillListControl(cmbTickets, "TicketInfo", "TicketID", dt, true, "--- Choose a ticket ---"); }
private void LoadCustomers() { DataTable dtCustomers = DataAccess.GetData("SELECT CustomerID,FirstName + ' ' + LastName AS CustomerName FROM Customer"); UIUtilities.FillListControl(cmbCustomers, "CustomerName", "CustomerID", dtCustomers, true, ""); }