troubleshooting Question

FCK Editor & MSSQL

Avatar of el_scotty
el_scottyFlag for United States of America asked on
.NET ProgrammingASP.NET
2 Comments1 Solution465 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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
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 1 Answer 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