Restrict tags while storing data into databse usng CKEditor

Question

I have CkEditor in my webpage,but the problem is while storing the data into database
it's storing like <p>text</p><img src=""/>,so while retrieving it's like unformated data,that's y I want to restrict the tags while storing the CKEditor data into database...can any one help me plz,its urgnt???

priya Avanigadda · Answer

Again I changed HttpUtility.HtmlEncode("jobdescription") instead of HttpUtility.HtmlEncode(ds.Rows[0][11]) its not showing any error bt Im getting the data with tags "jobdescription" is the column name in database

priya Avanigadda · Answer

I mentned lik diz: protected void Page_Load(object sender, EventArgs e) { DataSet ds = objview.display(); dt = ds.Tables[0]; foreach (DataRow row in dt.Rows) { HttpUtility.HtmlEncode(dt.Rows[0][11]); } DataView dtView = new DataView(dt); GridRec.DataSource = dtView; GridRec.DataBind(); }

priya Avanigadda · Answer

Im getting the error: Cannot find column 11 bt in my database tht column no is 11 only

priya Avanigadda · Answer

cn u check once in MSVS bz when I wz tryng to add the statement like "for(int i=0;i<objview.display().)"Im nt getting either rows or count in intellisense,bz of tht reason only tht error is cmng

Khan Abrar Ahmed · Answer

HI try to check this code DataSet ds = objview.display() ;// check here this is giveing the output proper or not DatTable dt = ds.Table[0]; foreach (DataRow row in dt.Rows) // Loop over the rows. { //add the decode code here //HttpUtility.HtmlEncode(your string) } DataView dtView = new DataView(dt); GridRec.DataSource = dtView; GridRec.DataBind();

priya Avanigadda · Answer

ya I checked with breakpoint bt I'm nt getting any row. If use objview.display().rows or count thn Im getting error like: Error112'System.Data.DataSet' does not contain a definition for 'rows' and no extension method 'rows' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference? cn u help me abt diz

Khan Abrar Ahmed · Answer

Hi can you put the debugger and check how many rows u are getting in dt.Rows, instead of this used objview.display().rows or count.

priya Avanigadda · Answer

if I mentned Row[i] also im getting sme error

Khan Abrar Ahmed · Answer

HI, protected void Page_Load(object sender, EventArgs e) { for (int i =1; i > dt.Rows.Count;i++) { dt.Rows[i][11] = HttpUtility.HtmlEncode(dt.Rows[ i ][11]); } GridRec.DataSource = objview.display(); GridRec.DataBind(); }

priya Avanigadda · Answer

I mentioned like diz: protected void Page_Load(object sender, EventArgs e) { for (int i =1; i > dt.Rows.Count;i++) { dt.Rows[0][11] = HttpUtility.HtmlEncode(dt.Rows[0][11]); } GridRec.DataSource = objview.display(); GridRec.DataBind(); } bt im getting the error like:"There is no row at position 0"

priya Avanigadda · Answer

cn we mention like diz dt.Rows[0][11]=HttpUtility.HtmlEncode(dt.Rows[0][11]);

priya Avanigadda · Answer

Thank u fr ur hlp bt im getting diz error : Error112'System.Data.DataSet' does not contain a definition for 'rows' and no extension method 'rows' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference?)E:\Projects - Net\RecruitMgr\Recruit\Recruit\ViewRequirement.aspx.cs1843Recruit

Khan Abrar Ahmed · Answer

HI, protected void Page_Load(object sender, EventArgs e) { //Add the loop herer and use the code //HttpUtility.HtmlEncode(your string) //like for(i=0,i objview.display().rows.count;i++) { //suppose your value in 1st columne try to change the loop and values then objview.display().rows[i].column[1] = HttpUtility.HtmlEncode( objview.display().rows[i].column[1]) ) } GridRec.DataSource = objview.display(); GridRec.DataBind(); }

priya Avanigadda · Answer

viewDetails.DAL: public DataSet display() { SqlConnection con = DbCon.OpenCoonection(); SqlCommand cmd = new SqlCommand("USp_ViewRequirementdetails", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds,"Tbl_RequirementModule"); DbCon.CloseConnection(); return ds; } viewDetails.aspx.cs: protected void Page_Load(object sender, EventArgs e) { GridRec.DataSource = objview.display(); GridRec.DataBind(); }

priya Avanigadda · Answer

ya sure

Khan Abrar Ahmed · Answer

can you please share the code where your are binding the gridview

priya Avanigadda · Answer

bt in asp.net page I'm not using any string just im using Gridview,I dnt hve any string then hw cn I mention tht statement

Khan Abrar Ahmed · Answer

Hi you can add this line when u are fetching the record from database in asp.new code.

priya Avanigadda · Answer

Where I have to add that statement while retrieving page or adding page...where shall I add

Khan Abrar Ahmed · Answer

HI in your code you can try to use below code HttpUtility.HtmlEncode(your string)

priya Avanigadda · Answer

Is it possible to remove the tags while retrieving the data from database into gridview

priya Avanigadda · Answer

no after adding that code into config.js,its adding data into database with tags

Khan Abrar Ahmed · Answer

Hi in ckeditor config.js file you can add below tags and try config.ignoreEmptyParagraph = true; config.forcePasteAsPlainText = false; config.pasteFromWordCleanupFile = 'default'; config.pasteFromWordNumberedHeadingToList = false; config.pasteFromWordPromptCleanup = false; config.pasteFromWordRemoveFontStyles = true;//Change by Abrar config.pasteFromWordRemoveStyles = true; config.removeDialogTabs = ""; config.removeFormatAttributes = "lang,width,height,align,hspace,valign"; config.removeFormatTags = "big,code,del,dfn,em,i,ins,kbd,q,samp,small,strike,tt,u,var"; config.format_h1 = "{ element : 'h1' }"; config.format_h2 = "{ element : 'h2' }"; config.format_h3 = "{ element : 'h3' }"; config.format_h4 = "{ element : 'h4' }"; config.format_h5 = "{ element : 'h5' }"; config.format_h6 = "{ element : 'h6' }"; config.format_tags = 'p;pre;address;div';