Solved

ASP.Net add formating to MSSQL query result

Posted on 2010-08-13
3
432 Views
Last Modified: 2013-11-15
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
Comment
Question by:brasso_42
  • 2
3 Comments
 
LVL 5

Expert Comment

by:almander
ID: 33431235
See this for information on the font tag
http://www.w3schools.com/tags/tag_font.asp
0
 
LVL 5

Accepted Solution

by:
almander earned 500 total points
ID: 33431256
Select Salu + '<br><font face="Arial" size="10"> <i> ' + Fname + '</i> </font><br>' + Sname
From NamseTable
where id = 1
0
 
LVL 1

Author Closing Comment

by:brasso_42
ID: 33431263
spot on many thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question