hello all,i like to develop a display system.which displays available PCs in a lab.i have written a sql procedure,which returns 8 values(no of PC's currently available in each room) i like to store these values in a table.i am using sql server 2000,IIS,ADO and ASP
i got following doubts
1)how can i display each value in a table cell.
2) is it possible to refresh the table alone? so that front end queries the database and fetches the result in alloted time.
3)when ever page gets refreshed ,it opens a connection and closes it.is it a good practice? is it possible to open a connection and without closing it ,querying the DB continously.
if u got some inputs pls guide me ..its my first ASP prg.thx in advance