Solved

tinymce into SQL

Posted on 2012-03-22
1
426 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 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