Click here to Skip to main content
15,881,248 members
Articles / Web Development / ASP.NET
Article

Multi Line GridView Column Cell

Rate me:
Please Sign up or sign in to vote.
2.90/5 (16 votes)
12 Nov 2007CPOL 85.7K   4   31   3
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)


Written By
Chief Technology Officer Compuacademy.net
United States United States
More than 15 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 Pin
Donsw26-Nov-08 16:55
Donsw26-Nov-08 16:55 
GeneralBetter title - Render HTML in GridView Cell Pin
Jcmorin12-Nov-07 10:54
Jcmorin12-Nov-07 10:54 
GeneralRe: Better title - Render HTML in GridView Cell Pin
T.Ashraf12-Nov-07 19:08
T.Ashraf12-Nov-07 19:08 

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

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