private void pckCustomer_ItemSelected(object sender, mmPickerItemSelectedEventArgs e) { 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 ); }But if the code is put in multiple lines like below, it gives me an error:
private void pckCustomer_ItemSelected(object sender, mmPickerItemSelectedEventArgs e) { 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 ); }What's wrong here? It seems that it does not recognize multiple lines...