>What an ugly construct. And almost completely unreadable. I'd hate to maintain that code base. lol
So of these two you consider the second as being more readable and maintainable ?:
this.oOrder.GetOrdersByCustomerID(@"Select Orders.OrderID,
Orders.OrderDate, Orders.RequiredDate,
Orders.ShippedDate, Orders.ShipName,
Customers.ContactName From Orders, Customers
Where Orders.CustomerID = Customers.CustomerID And
Orders.CustomerID Like '%"+this.pckCustomer.Text+"%'", 1 );
or
this.oOrder.GetOrdersByCustomerID("Select Orders.OrderID, "
+ "Orders.OrderDate, Orders.RequiredDate, "
+ "Orders.ShippedDate, Orders.ShipName, "
+ "Customers.ContactName From Orders, Customers "
+ "Where Orders.CustomerID = Customers.CustomerID And "
+ "Orders.CustomerID Like '%"+this.pckCustomer.Text+"%'", 1 );