Hi,
In a button click event, see code, there is a union select statement and the results should be
shown in GridView1. However, only the results of the first select are returned. The page size of the
Grid view is set to 25. Maybe 2 queries would be better?
System.Data.DataSet FindFlights(string pleaving, string parriving, string pclass, string poutbound, string pinbound)
{
OracleConnection con = new OracleConnection("Data Source=DEV01;Persist Security Info=True;User ID=xxx;Password=xxx;Unicode=True");
string queryString = "";
queryString = "SELECT to_char(FD.FLIGHT_DATE, 'DY')||'.'|| FD.FLIGHT_DATE AS DATE_HEADER, " +
"FD.FLIGHT_DATE AS TRAVEL_DATE, " +
"LM.STD AS DEPART, " +
"LM.FNR AS FLIGHT, " +
"LM.STD ||' '|| LM.DEP ||' - '|| LM.STA ||' '|| LM.ARR AS SCHEDULE, ...
Go to the complete details ...