I have an htmlTable that I assemble, based on a SQL query.

htmlTableRow = New HtmlTableRow
htmlTableCell = New HtmlTableCell
htmlTableCell.InnerHtml = colServerList(intCounterServerListCol)
htmlTableCell.Attributes.Add("class", "body2")
htmlTableRow.Cells.Add(htmlTableCell)
tbl_Results.Rows.Add(htmlTableRow)

and it shows up in my HTML in a table called tbl_Results. Works OK
however --

I have data that I want to pre-populate into the first column, and the
add in the data in column two and three from the SQL query. Right no
it shows nothing but the first row, and when I create two more row
with   for the SQL query, I want to populate just those cells wit
the query.

Is there anyway to create a table, then change it cell by cell? Do
have to name each cell? Pls post if you can help, or if you have an
questions about this question.

»» The SQL Query takes about a minute, and I want to show the firs
column and then populate the other columns as the data comes in th
from the query. ««

possible solutions I am evaluating:
1. Display a page that shows the first column, then when the query i
done, redirect to the actual results page and recreate the table (
don't like this solution).
2. Set the name for each row, and then populate column 2 and 3 when th
query is done, based on the name of the row (I like this, but I'm no
sure if it's feasible).
3. Use a DataGrid to populate the first column, then the DataGrid t
populate column 2 and 3 when the query is returned. I am not using
DataGrid right now, so I do not prefer this solution, unless it's easy
;

--
bh_jodokas
-----------------------------------------------------------------------
bh_jodokast's Profile: http://www.highdots.com/forums/m97
View this thread: http://www.highdots.com/forums/t301457

I solved this (with some help) by:


Code
-------------------
If cnnDataReader.HasRows Then
Do While cnnDataReader.Read
colAllTriage.Add(cnnDataReader.Item("fld_patient_id"))
colAllTriageList.Add(" : " & cnnDataReader.Item("fld_patient_title"))
Loop
test.InnerHtml = "<script language=""Javascript"">document.all.pleasewaitScreen.style.visibility=""hidden"";</script>"
Else
colAllTriage.Add("&nbsp;")
colAllTriageList.Add("&nbsp;")
End I
-------------------


Now if there is no data, it shows blank cells! Also, since ther
technically is data now from the get go, I moved the pleasewaitScree
to hide after actual data is added.

Hope this helps someone

--
bh_jodokas
-----------------------------------------------------------------------
bh_jodokast's Profile: http://www.highdots.com/forums/m97
View this thread: http://www.highdots.com/forums/t301457