Display DataTable in HTML Table layout in ASP.Net using C# and VB.Net

Your Idea was fabulous but i did that from another way beacuse it was generated through stored procdure and have lenghty data.

There I applied same idea with different way.

Dim inputData As DataTable = DBH.GetDataTable(SqlStr)
inputData.Columns.Add("Particulars", GetType(String))
inputData.Columns.Add("Amount", GetType(String))
Dim inputColumnNames As String() = {"SrNo", "TripDate", "OrderNos", "CNDoNo", "Particulars", "Amount", "TotalAmtWithoutTax"}
For Each row As DataRow In inputData.Rows
    Dim Particulars As String = $"<B>{row("Description")}</B></br>  {row("ContainerType")} VehicalNo: {row("VehicalNo")} </br> {row("OtherChargesTxt")} </br> {row("TaxPercentage")}"
    Dim Amount As String = $"<B>{row("TransCharges")}</B></br></br>  {row("OtherChargesV")} </br> {row("TaxAmt")} </br>"
    row("Particulars") = Particulars
    row("Amount") = Amount
Next
Dim Sb As StringBuilder = New StringBuilder
' Create the HTML table
Sb.Append("<table cellpadding='5' cellspacing='0' style='border: 1px solid #ccc;font-size: 9pt;font-family:Arial;width:100%'>")
Sb.Append("<thead>")
Sb.Append("<tr>")
For Each columnName As String In inputColumnNames
    Sb.Append("<th>" & columnName & "</th>")
Next
Sb.Append("</tr>")
Sb.Append("</thead>")
For Each row As DataRow In inputData.Rows
    Sb.Append("<tr>")
    For Each columnName As String In inputColumnNames
        Sb.Append("<td style='width:100px;border: 1px solid #ccc'>" & row(columnName).ToString() & "</td>")
    Next
    Sb.Append("</tr>")
Next
Sb.Append("</table>")
PlaceHolder1.Controls.Add(New Literal() With {.Text = Sb.ToString()})