How To display Data From Database 2

[ajap99]

I am developing a room booking app
On the booking page I need to display the bookings for 3 rooms for that particular day.
I am using a calander on the booking page
I am connecting to a MS Access database.
I guess I will have to use a SQL query to get this info, but what is the best, easiest way to display this

 

[ArizonaRedneck]

just put them into a datagrid

 

[ArizonaRedneck]

if you want it to look nicer, I'd use a datalist (you can format it easier).

 

[ca8msm]

To return the result you are correct in assuming you will use SQL to determine which results are returned.

If you do decide to use a datagrid to display the data to the user there is an example that you can use at:

http://www.developer.com/net/asp/article.php/2210191

This shows you not only how to display the data, but also allow your users to edit it.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.