Hello all - thank you for reading my post.
I'm still new to ASP.NET, and I'm trying to rewrite a simple booking/reservation system I did in ASP, but I'm struggling to find an equivalent technique in ASP.NET.
Basically, it a nested recordset. The first recordset returns weeks from a calendar. for each record returned, a basic table row is created, showing the dates & prices then the start of the week is used to query a bookings table to see if there are any bookings for that week.
If there are bookings, the <tr> & <td> tags are modified to change to colour & wording to reflect the bookings.
an extract of the code is as follows:
---------------------------------------
dim strStart_of_Week, strEnd_of_Week, strMid_Week, strWeek, strWeekPrice, strMidWeekPrice, strWeekendPrice, strDays, strStatus, strColour, strYear
dim RS_Cal
openDB
strSQL = "Select week, Week_Price, ...
Go to the complete details ...