Do a Select and see if the data in the db is indeed stored as HTML first.
dr.GetSqlXml shoukd have worked if the data was XML/HTML.
--
With Regards
Shailen Sukul
..Net Architect
(MCPD: Ent Apps, MCSD.Net MCSD MCAD)
Ashlen Consulting Services
http://www.ashlen.net.au
<jo*******@gmail.comwrote in message
news:11**********************@i12g2000cwa.googlegr oups.com...
>I tried this with no avail.. Any other ideas?
Shailen Sukul wrote:
>try dr.GetSqlXml
--
With Regards
Shailen Sukul
.Net Architect
(MCPD: Ent Apps, MCSD.Net MCSD MCAD)
Ashlen Consulting Services
http://www.ashlen.net.au
<jo*******@gmail.comwrote in message
news:11*********************@f1g2000cwa.googlegro ups.com...
I'm trying to grab some text from my database that is html formatted.
The problem is all the html formatting is lost when I try and get it
from my SqlDataReader.
sqlCmd = new SqlCommand(sqlQuery, sqlConn);
sqlRead = sqlCmd.ExecuteReader();
while (sqlRead.Read()) {
FCKeditor.Value = sqlRead.GetString(0);
}
This obviously isn't the right way to do it.. any ideas?