Q:Read two rows from table

LegoMan · October 10th, 2003, 01:08 AM

i wanna read two rows from a table inside a database and display in a text box.

2 fields in table
---------------
id topic
1stID this is first id
2ndID This is second id

ie.

if ID = "1stID"
cell1.innertext = "this is first id"
end if
if ID = "2ndID"
cell2.innertext = "this is second id"
end if

prob doesn't make any sense, but i wanna display 2 rows from a table. But what would i do in the SQL statement. i am able to retrieve the 2 rows i want. but how to make the cell in a html table display corresponding topics.

LegoMan

life_s Ng · October 13th, 2003, 01:07 AM

hi, what do u mean by cell...? is it a text box?
Sorry, i very blurr to ur question...

Regards
life's Ng

LegoMan · October 13th, 2003, 02:15 AM

OK. maybe i should make it simpler.

i want to display 2 fields from a table inside a database. each field being inside cells inside a table.

so i wanna find via the id.

does that make sense? i thought would have to do 2 sql statements to retrieve a listing then bind it to a rs.

rodmcleay · October 13th, 2003, 08:19 PM

I am only learning aspx now so their may be a better solution but I was in the same situation last week.

I ended up putting an <asp:literal id="myLitControl"/> control in the table cell and then changed its Text attribute in my code behind.

Hope this helps

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

jacob · October 14th, 2003, 01:22 PM

If you have a reference to the table to which you want to add the cells you are able to do this dynamically. A table has got a Rows collection which enables you to add rows and rows has a Cells collection. A small example...

Code:

Table table = new Table();
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Controls.Add(new LiteralControl("something"));
table.Rows.Add(row);
row.Cells.Add(cell);

[not tested]

This example shows how to build a table dynamically i C#; it adds a cell to a row, and add that row to the table. If you have a reference to the table on your page you can do the same.

Hope it helps

Jacob.