Solved

ASP.Net add formating to MSSQL query result

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Introduction HyperText Transfer Protocol (http://www.ietf.org/rfc/rfc2616.txt) or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video teaches users how to migrate an existing Wordpress website to a new domain.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

688 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