private void DevolucionForm_Load(object sender, EventArgs e)
{
pnrTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
pnrTextBox.KeyPress += this.InputNumField_KeyPress;
pnrTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection col = new AutoCompleteStringCollection();
string queryCompras = "SELECT P.Com_PNR Com_PNR FROM TS.Pasaje as P, TS.Viaje as V";
queryCompras += " WHERE P.Can_Cod IS NULL AND P.Viaj_Cod = V.Viaj_Cod AND V.Fecha_Llegada IS NULL AND V.Viaj_Borrado = 0";
queryCompras += " UNION SELECT E.Com_PNR FROM TS.Encomienda as E, TS.Viaje as V";
queryCompras += " WHERE E.Can_Cod IS NULL AND E.Viaj_Cod = V.Viaj_Cod AND V.Fecha_Llegada IS NULL AND V.Viaj_Borrado = 0";
DbComunicator db = new DbComunicator();
db.CargarAutocomplete(col, queryCompras, "Com_PNR");
pnrTextBox.AutoCompleteCustomSource = col;
db.CerrarConexion();
}