Restrict tags while storing data into databse usng CKEditor

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

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();
}

Im getting the error:

Cannot find column 11


bt in my database tht column no is 11 only

cn u check once in MSVS bz when I wz tryng to add the statement like "for(int i=0;i

0

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();

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

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.

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();
}

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"

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();

           

        }

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:

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

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

HI in your code you can try to use below code

HttpUtility.HtmlEncode(your string)

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

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';