troubleshooting Question

FCK Editor & MSSQL

Avatar of el_scotty
el_scottyFlag for United States of America asked on
.NET ProgrammingASP.NET
2 Comments2 Solutions465 ViewsLast Modified:
Re: ASP.net 2.0.
Hi folks, I'm looking for a straight & simple OUTLINE of saving FCKeditor text to a MSSQL database, and retrieving it back 2 ways (2 pages) - for editing, and displaying in HTML.

My app has an admiin form which contains the FCKeditor: ID=FCKeditor1
I want to save the value of its contents to an MSSQL field (I have a nvarchar type set).
Also, the application currently follows procedure of writing form values to a Public Shared variable, before being written to the DB. I am assigning the value of FCKeditor to a variable of (lets call it myEvent.Header (string type)) before writing to DB. ie.
myEvent.Header = FCKeditor1.Value ...Then my SQL Insert or Update clause will post FCK stuff into the DB by parameter '.AddWithValue("@Header", Header)'

At current try it is not writing anything to DB, so...
I need to be able to save the FCKeditor contents to the DB and repopulate its contents from the DB when I open the admin form to edit the record. Also , I have a separate 'public' Events page which will have a div to render the saved RTF/HTML from the DB.

In your answer, please tell me if - validateRequest='false' is important in the page directive for either the admin(edit) page or the public HTML display page.

Thanks ahead

ASKER CERTIFIED SOLUTION
el_scotty

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros