ASP.NET and C# fill a table with data from database

Question

I've created a table with some C# and asp.net for be filled by data from a database, but when I add data to the table, the data is going to the same row. I want to put data in multiple rows.

Some code I have used is:

int tmp = 0;
TableRow tabelaLinhas = new TableRow();
while (tmp < dados.Rows.Count)
{
 TableCell celula = new TableCell();
 celula.Controls.Add(new LiteralControl(dados.Rows[tmp]["nome"].ToString()));
 tabelaLinhas.Cells.Add(celula);
 tabela.Rows.Add(tabelaLinhas);

 CheckBox caixa = new CheckBox();
 caixa.ID = dados.Rows[tmp]["nome"].ToString().Replace(" ", "").ToLower() + "CheckBox";
 celula = new TableCell();
 celula.Controls.Add((Control)caixa);
 tabelaLinhas.Cells.Add(celula);
 tabela.Rows.Add(tabelaLinhas);

 tmp++;
}

Brian Mains · Accepted Answer · 2010-12-18 01:53:21Z

2

Move

TableRow tabelaLinhas = new TableRow();

into the while loop; you are only creating one row object, even though you are adding multiple times. New instances need created in every while iteration.

HTH.

answered Dec 18, 2010 at 1:53

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kubi · Accepted Answer · 2010-12-18 01:57:52Z

0

write

tabelaLinhas = new TableRow();

under

tabela.Rows.Add(tabelaLinhas);

answered Dec 18, 2010 at 1:57

Kubi

2,1997 gold badges35 silver badges62 bronze badges

Collectives™ on Stack Overflow

ASP.NET and C# fill a table with data from database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related