Extract plain text from HTML text in asp.net

Question

I have used a rich textbox control,ckeditor in my case,When any formatting is done to the text the formatted text is populated in the datagrid.But I want to extract only the plain text in the grid and trim the length of data to 80 characters while populating.

The query for updating the answer is as follows

    protected void btnUpdate_Click(object sender, EventArgs e)
    {

        if (txtEditorAnswer.Text.Trim() != string.Empty)
        {

            int intIsUpdated = 0;
            string strUpdateQuery = "UPDATE M_QA SET ANSWER = '" + txtEditorAnswer.Text.Trim().Replace("'", "''")
                                  + "', UPDATED_ON = getDate(), UPDATED_BY = '" + this.Session["UserId"].ToString()
                                  + "' WHERE PK_ID = " + _currentQuestionId + " AND IS_ACTIVE = 1";

and the query for populating data in the grid is as follows:

    protected void LoadQA(int intQuestionId)
    {
        string strSelectQuery = "SELECT REPLACE(TITLE, '\n', '<br />') TITLE, REPLACE(DESCRIPTION, '\n', '<br />') DESCRIPTION, "
                                + "ANSWER, FK_OWNER_ID, CREATED_ON FROM M_QA WHERE PK_ID = "
                                + intQuestionId + " AND IS_ACTIVE = 1";

can plz some buddy help me!!

Gregoire · Accepted Answer · 2010-10-20 06:58:02Z

2

Use the HTML agility pack, parse your query result on ItemDataBound event then select only the text() nodes to display

answered Oct 20, 2010 at 6:58

Gregoire

24.9k7 gold badges50 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract plain text from HTML text in asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related