Welcome to Code Forum!
Join a community that supports you and your coding journey from day one. We strive to be a friendly, supportive community that empowers everyone to be better developers. By registering with us, you'll be able to discuss, share and private message with other members of our community.
-
Guest, before posting your code please take these rules into consideration:
- It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
- You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
- Don't share a wall of code. All we want is the problem area, the code related to your issue.
To learn more about how to use our BBCode feature, review our "How to post your code into threads" here.
Thank you, Code Forum.
C# Trying to display SQL data better
- Thread starter Gussy81
- Start date
Solution
JosiahMaybe
Platinum Coder
Gussy81
Coder
Oh sorry about that. Here it is:
ASP.net:
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
Bronze Coder
It's just a matter of enhancing your
(I haven't tested this code, but I think it should be ok)
stringBuilder to include the HTML for a table, for example like this
ASP.net:
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
Coder
Beautiful!! thats just what i needed. thank you
cbreemer
Bronze Coder
No problem. If my code helped you out, don't forget to mark my post as the Solution.
New Threads
-
-
-
What Should I Look for in a Link-Building Service for Restricted Industries?
- Started by kemiy
- Replies: 2
-
-
Where Can I Find the Correct AetherSX2 BIOS for Europe?
- Started by kemiy
- Replies: 1
Share this page
Buy us a coffee!
