i have four table which is (Reservation, ReservationRoom )and (Redemption,RedemptionRoom)..both the Reservation and Redemption table have the same attribute but different data.
is it possible to load both table event into the scheduler?
currently i am able to load the scheduler with the Reservation table only.
im doing it like this
private DataTable DbGetEvents(DateTime start, DateTime end)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM ReservationRoom rr
INNER JOIN Reservation r ON rr.reservationId=r.reservationId
WHERE NOT (([checkOutDate] <= @start) OR ([checkIndate] >= @end))", ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
da.SelectCommand.Parameters.AddWithValue("start", start);
da.SelectCommand.Parameters.AddWithValue("end", end);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}