C# Trying to display SQL data better

[Gussy81]

Hi, I am display all rows from my SQL table but it's all getting displayed in one label in a block. Can I break it down and assign a label for each table column? My code is below.

 

[JosiahMaybe]

@Gussy81, not seeing your code, can you post it please?

 

[Gussy81]

Oh sorry about that. Here it is:

if (dt2.Rows.Count > 0)
{
    StringBuilder stringBuilder = new StringBuilder();
    foreach (DataRow row in dt2.Rows)
    {
        stringBuilder.Append("Client Ref: ").Append(row["client_ref"]).Append("<br/>");
        stringBuilder.Append("Crosk Ref: ").Append(row["crosk_ref"]).Append("<br/>");
        stringBuilder.Append("Client Name: ").Append(row["client_name"]).Append("<br/>");
        stringBuilder.Append("Section Name: ").Append(row["section_name"]).Append("<br/><br/>");
    }
    CLIENTREF.Text = stringBuilder.ToString();
}
else
{
    CLIENTREF.Text = "No records found!";
}

 

[cbreemer]

It's just a matter of enhancing your stringBuilder to include the HTML for a table, for example like this

    stringBuilder.Append("<table>");  
    foreach (DataRow row in dt2.Rows)
    {
        stringBuilder.Append("<tr>")
        stringBuilder.Append("<td>Client Ref: ").Append(row["client_ref"]).Append("</td>");
        stringBuilder.Append("<td>Crosk Ref: ").Append(row["crosk_ref"]).Append("</td>");
        stringBuilder.Append("<td>Client Name: ").Append(row["client_name"]).Append("</td>");
        stringBuilder.Append("<td>Section Name: ").Append(row["section_name"]).Append("</td>");
        stringBuilder.Append("</tr>")
        }
  
    stringBuilder.Append("</table>");

(I haven't tested this code, but I think it should be ok)

 

[Gussy81]

It's just a matter of enhancing your stringBuilder to include the HTML for a table, for example like this

    stringBuilder.Append("<table>"); 
    foreach (DataRow row in dt2.Rows)
    {
        stringBuilder.Append("<tr>")
        stringBuilder.Append("<td>Client Ref: ").Append(row["client_ref"]).Append("</td>");
        stringBuilder.Append("<td>Crosk Ref: ").Append(row["crosk_ref"]).Append("</td>");
        stringBuilder.Append("<td>Client Name: ").Append(row["client_name"]).Append("</td>");
        stringBuilder.Append("<td>Section Name: ").Append(row["section_name"]).Append("</td>");
        stringBuilder.Append("</tr>")
        }
 
    stringBuilder.Append("</table>");

(I haven't tested this code, but I think it should be ok)

Beautiful!! thats just what i needed. thank you

 

[cbreemer]

Beautiful!! thats just what i needed. thank you

No problem. If my code helped you out, don't forget to mark my post as the Solution.