How to bind limited richtext from database in div tag using ASP.NET C#?

Should I Re-Install Visual Studio?

If it's showing Aggregate, All, Any, etc., that would suggest your FreeTextBoxDescription variable is a collection, not a reference to a single control.

Are you absolutely sure you're putting the dot after FreeTextBoxDescription, and not FreeTextBoxDescription.ToString()?

That code's reading directly from the database, not from a FreeTextBox control.

yes sir so how could i read the limited text ?? and that data which is present in database is richtext data which inserted from freetextbox control.

It depends how complicated you want to get. You could use a couple of regular expressions to strip out the HTML; or you could use something like this Html Agility Pack sample[^] to convert your HTML to plain text.

I just want to retrieve starting 200 words only form the data base , so i used x.BlogDescription.ToString().SubString(200), it display starting 200 characters from the data with html tags. i dnt want those html tags that's why i am asking the question about which method is used for retrieving limited tex frm database which contains html tags.

A simple solution:

public static string RemoveHtmlTags(string input, int maximumLength)
{
    // Remove the HTML tags:
    string text = Regex.Replace(input, "<[^<>]*>", string.Empty);
    
    // Limit the length:
    if (text.Length > maximumLength)
    {
        text = text.Substring(0, maximumLength);
    }
    
    return text;
}

You mean I need to write something like this : RemoveHtmlTags(x.Blogdescription.ToString().Substring(0,200)) ????
or
x.BlogDescription(RemoveHtmlTags).ToString().SubString(0,200) ?

or

RemoveHtmlTags(x.BlogDescription, 200) ???

Well I tried this RemoveHtmlTags(x.BlogDescription,200)

It removes the html text but max length is not working, it binds whole text?

Sorry, part of the code block was missing. The line:

text.Substring(0, maximumLength);

should be:

text = text.Substring(0, maximumLength);

@Karthik , @Richard

Thanks Alottt sir, both of helped me alottt... I am very gratefull to you.
Now Everythings working awesome. Again Thanks Alottt :)

public static string RemoveHtmlTags(string input, int maximumLength)
{
// Remove the HTML tags:
string text = Regex.Replace(input, "<[^<>]*>", string.Empty);

// Limit the length:
if (text.Length > maximumLength)
{
text = text.Substring(0, maximumLength);
}

return text;
}

using(Database db = new Database())
{
var query = (
from c in db.tblBlogs

select new
{

c.BlogDescription
}).OrderBy(d => d.id).ToList().Take(10);

System.Text.StringBuilder sb = new System.Text.StringBuilder();

query.ToList().ForEach(x =>
{
sb.Append(String.Fotrmat("{0}",RemoveHtmlTags(x.BlogDescription,200));

blogdiv.InnerHtml = sb.ToString();
}
}