Click here to Skip to main content
Click here to Skip to main content

Multi Line GridView Column Cell

, 12 Nov 2007 CPOL
Rate this:
Please Sign up or sign in to vote.
Display multi line of text saved in the database

Introduction

I was working on a project , where I had to retrieve what was saved in the database and display it in the same cell, but multi line. Since the data was saved in the format of <br>, it was easy for me to display it.

  1. Create a new project using C#.

  2. Create a table in the database (SQL or MYSQL table or any other database):

    Screenshot - T7.jpg

  3. Save some data to the table. For example:

    Screenshot - T6.jpg

  4. Before you save the data to the table, replace the \r\n with <br>:

    Screenshot - T5.jpg

  5. Drag and drop GridView from the Tool Kit to the Web form.

  6. Create the following columns:

    Screenshot - T1.jpg

  7. Gridview will appear like this:

    Screenshot - T2.jpg

  8. Change the property of the Message column as shown below:

    Screenshot - T3.jpg

  9. Set the HtmlEncode to false.

  10. Write the code to fill the GridView. Here is a sample:

    Screenshot - T4.jpg

  11. The data will appear like this:

    Screenshot - T8.jpg

Points of Interest

It can be used to display text file data saved in the database.

It was very nice and easy to display multi lines of text in one cell. What we need to do is set the HtmlEncode property to false.

History

  • 12th November, 2007: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

T.Ashraf
Technical Lead TANVTECH
United States United States
More than 13 years of experience in design, architecture and development of various commercial objects oriented application.Other Specialties

Data Migration:
• MS Access database to SQL 2005/2008
• MS Access database to Oracle
• MS Access database to My SQL
• FoxPro to SQL

Application Migration:
• Converted MS Access application to .net web application (Asp.net)
• Excel Application to .net 3.5 web application
• FoxPro application to .net 3.5
Reporting development and support
• MS access reports
• Crystal reports
• SQL Reports(SSRS)
• DevExpress reports
• Cognos reports
Application development and support
• .net Application web /Win forms
• SharePoint
• MS Access
• Website
• Ecommerce
• WCF
• Web Services
3rd Party Control Support
• DevExpress
• .netForum
• Telerik
Version controls Support
• Team Foundation Server
• Source Safe
• CVS
• SVN

Comments and Discussions

 
GeneralMy vote of 2 PinmemberDonsw26-Nov-08 17:55 
GeneralBetter title - Render HTML in GridView Cell PinmemberJcmorin12-Nov-07 11:54 
GeneralRe: Better title - Render HTML in GridView Cell PinmemberT.Ashraf12-Nov-07 20:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141223.1 | Last Updated 12 Nov 2007
Article Copyright 2007 by T.Ashraf
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid