.NET (Core and Framework)

 public static DataTable GetFlightsByDate(DateTime datefile)
        {
            DataTable GetFlights=new DataTable();
            string query = "SELECT TOP (20) Pax_No, Chd_no,"+                        
				            "Hotel_Id, DateFile, DEST, DEST_D, TypeTransfer, ARR_FLT, AT_Arr, DEP_FLT"+
"FROM  V_Report_Rooming_List_Trsf where DateFile=@DateFile";
            SqlConnection con = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.Parameters.Add(new SqlParameter("@DateFile",datefile));
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            sdr.Fill(GetFlights);
            return GetFlights;
        }