Solved

tinymce into SQL

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

636 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