Solved

ASP.Net add formating to MSSQL query result

Posted on 2010-08-13
3
435 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
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…

742 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