Exemple #1
0
        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 ---");
        }
Exemple #2
0
        private void LoadCustomers()
        {
            DataTable dtCustomers = DataAccess.GetData("SELECT CustomerID,FirstName + ' ' + LastName AS CustomerName FROM Customer");

            UIUtilities.FillListControl(cmbCustomers, "CustomerName", "CustomerID", dtCustomers, true, "");
        }