Solved

tinymce into SQL

Posted on 2012-03-22
1
428 Views
Last Modified: 2012-05-14
Hi,

I have successfully setup Tinymce on my text area and it displays text fine, but when I submit text in it to be saved into my SQL database it removes the tags <p> and replaces with &lt;p&gt;

Is there anyway to stop this??

Code Below

string LongArticle = txtArticle.Text;

tring query1 = "UPDATE smartChimps_news SET date=convert(datetime,'" + dateNew + "',103) , heading='" + Heading + "', LongArticle ='" + LongArticle + "' WHERE newsid='" + newsid + "'";



Regards

Michael
0
Comment
Question by:hayward03
1 Comment
 
LVL 9

Accepted Solution

by:
gery128 earned 500 total points
ID: 37753389
You may want to decode text before inserting to database.
Try to use HtmlUtility.HtmlDecode method
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

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