Solved

ASP.Net add formating to MSSQL query result

Posted on 2010-08-13
3
434 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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

New Relic: Our company recently started researching several products to figure out what were the best ways for us to increase our web page speed and to quickly identify performance problems that we may be having. One of the products we evaluated wa…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
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…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

820 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