How to build a html table dynamically based on dataset

Question

I have a dataset

DataSet ds = Access.Get(startdate, enddate);

I returns me about 70 rows.I need to build an html table based on this to provide printing option. Any suggestions on how to do this? Thanks

The first 2 options I think about are nested loops or Linq. What have you tried? — Zohar Peled
– Zohar Peled, Commented Nov 24, 2017 at 7:04

Karthick Raju · Accepted Answer · 2017-11-24 07:06:40Z

1

Pass DataSet table to ConvertDataSetTableToHTML. Ensure your dataset always have table with records before calling.

if (ds != null)
{
    if (ds.Tables.Count >0 )
    {
        if (ds.Tables[0].Rows.Count > 0)
        {
            ConvertDataSetTableToHTML(ds.Tables[0]);
        }
    }
}
public static string ConvertDataSetTableToHTML(DataTable dt)
{
    string html = "<table>";
    //add header row
    html += "<tr>";
    for(int i=0;i<dt.Columns.Count;i++)
        html+="<td>"+dt.Columns[i].ColumnName+"</td>";
    html += "</tr>";
    //add rows
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        html += "<tr>";
        for (int j = 0; j< dt.Columns.Count; j++)
            html += "<td>" + dt.Rows[i][j].ToString() + "</td>";
        html += "</tr>";
    }
    html += "</table>";
    return html;
}

I just used the code from here for your scenario.

answered Nov 24, 2017 at 7:06

Karthick Raju

79710 silver badges34 bronze badges

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

6 Comments

Sam Daniel Over a year ago

But how to add the returned html to the aspx page

Karthick Raju Over a year ago

Can you try creating div in aspx like <div id="divDynamicHTMLTable" runat="server"></div> and in code behind file, divDynamicHTMLTable.InnerHtml= ConvertDataSetTableToHTML(ds.Tables[0]);? Place code behind change inside if condition by replacing ConvertDataSetTableToHTML(ds.Tables[0]);. I don't have VS with me at the moment, so try and let me know

Sam Daniel Over a year ago

I tried this and it worked <asp:Label ID="lblResult" runat="server"/> and string result = ConvertDataSetTableToHTML(dsPNPrint.Tables[0]); lblResult.Text = result;

Karthick Raju Over a year ago

Glad to hear. Can you mark the solution as answered?

Sam Daniel Over a year ago

But the styles are not applying. Any idea why?

|

Collectives™ on Stack Overflow

How to build a html table dynamically based on dataset

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related