forum

Home / DeveloperSection / Forums / Adding rows dynamically in a table in C# while populating data from sqlserver

Ask Question

Adding rows dynamically in a table in C# while populating data from sqlserver

Anonymous User173209-Dec-2014

I am retrieving data from sqlserver using Dropdown list box selected value and storing it in an arraylist. Now the problem is how to retieve the arraylist values and display in the table.

asp.netc# sql server 
Updated on 10-Dec-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

2 Answers

Anonymous User

Anonymous User

10-Dec-2014

Use it like below

    ArrayList myArrayList = new ArrayList(); 
    //Fill ArrayList values from the SQL Server
    myArrayList.Add("Hello");
    myArrayList.Add("World"); 
    Table table = new Table(); 
    foreach (var item in myArrayList)
    {
        TableRow tr = new TableRow();
        TableCell tc = new TableCell();
        //Add Arraylist item into TableCell to display it
        tc.Text = item.ToString();
        tr.Cells.Add(tc);
        table.Rows.Add(tr);
    }

Anonymous User

Anonymous User

10-Dec-2014

If you are using asp.net mvc you can use something like this: 

<table>
    @foreach (var item in List) {
    <tr>
        <td>
           item.somethingA
        </td>
        <td>
           item.somethingB
        </td>
 
    </tr>
}
</table>

etc to create table

Liked By