Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

ASP.Net add formating to MSSQL query result

Hi

I need to add some html formatting to a mssql query result.  E.g.

Select Salu + '<br>' + Fname + '<br>' + Sname
From NamseTable
where id = 1

Result = mr <br> john <br> smith
formated in html as
mr
john
smith

The above works fine, but I want to format fname to be font arial size 10pt and italic e.g.
mr
john
smith


I am then going to use this as a message body using EWS (if your wondering)

Many thanks

Brasso
0
brasso_42
Asked:
brasso_42
  • 2
1 Solution
 
almanderCommented:
See this for information on the font tag
http://www.w3schools.com/tags/tag_font.asp
0
 
almanderCommented:
Select Salu + '<br><font face="Arial" size="10"> <i> ' + Fname + '</i> </font><br>' + Sname
From NamseTable
where id = 1
0
 
brasso_42Author Commented:
spot on many thanks
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now