I have a BIG problem... I am really stuck on how to achieve this for aa hotel booking application. Here is a rate card for the hotel:- Jan 8th - March 31st Daily Rate = 19.00 Week Rate = 125.00 April 1st - June 30th Daily Rate = 20.00 Week Rate = 130.00 July 1st - Sept. 17th Daily Rate = 22.00 Week Rate = 140.00 Sept 18th - Dec 3rd Daily Rate = 20.00 Week Rate = 140.00 Dec 4th - Jan 7th Daily Rate = 21.00 Week Rate = 135.00 If someone stays for 10 days, they are charged a week rate and then 3 day rates... should someone stay for 14 days, they are charged 2 week rates, etc. If someone wants to stay 1 week and that stay overlaps rate periods ie, from dec 1st then they are charged the week rate as it is on their arrival day. If they were staying for 2 weeks from dec 1st, then the 1st week would be at one rate and the second week at a different rate. If someone was staying for 10 days for instance from dec 1st, then they would be charged 1 week @ 140.00 and 3 days at 21.00. I hope the above is understandable. If I know the start date and the end date, how the hell can work out the cost?? Any help would sure save me from buying more valium!! Rob

This IS possible by writing a COM object to query the computer state and then continually calling the COM object from an aspx page... Although it IS possible, the aspx page would have to have a very fast refresh rate in order to catch the shutdown, and frankly I do not see the point... (VERY BAD IDEA.... BAD PERFORMANCE AND VERY SLOW SERVER) Instead why dont you save the state of your asp.net application in a database so it matters not one bit if the server is shutdown... You can then reinstate the application state by firing off a subroutine in the global.asax file to retrieve the state from your DB. Hope this helps. Rob.

I have the following datagrid: (Taken from aspx page) Book this room I have this code in the code behind file.... Dim TempDate As Date = ArrivalDate.SelectedDate.AddDays(NumberofNights.SelectedIndex - 1) Dim start_stay As SqlClient.SqlParameter Dim end_stay As SqlClient.SqlParameter start_stay = New SqlClient.SqlParameter end_stay = New SqlClient.SqlParameter start_stay.ParameterName = "@start_stay" end_stay.ParameterName = "@end_stay" start_stay.SqlDbType = SqlDbType.SmallDateTime end_stay.SqlDbType = SqlDbType.SmallDateTime SqlCommand.CommandType = CommandType.StoredProcedure SqlCommand.CommandText = "availability" SqlCommand.Parameters.Add(start_stay) SqlCommand.Parameters.Add(end_stay) Dim Reader As SqlClient.SqlDataReader SqlCommand.Parameters("@start_stay").Value = ArrivalDate.SelectedDate.ToLongDateString SqlCommand.Parameters("@end_stay").Value = TempDate.ToLongDateString SqlConn.Open() Reader = SqlCommand.ExecuteReader If Reader.HasRows Then AvailableNotificationLabel.Text = "The following rooms are available, please tick the box next to the room(s) you require and click next" AvailableResults.Visible = True AvailableResults.DataSource = Reader AvailableResults.DataBind() Else AvailableNotificationLabel.Text = "Sorry, we have no availability on the dates you requested." P2Next.Enabled = False End If Reader.Close() SqlCommand.Dispose() SqlConn.Close() I get this error when databind is called:- DataBinder.Eval: 'System.Web.UI.WebControls.DataGridItem' does not contain a property with the name roomnumber. Roomnumber is a field that is return