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.
Create a new project using C#.
Create a table in the database (SQL or MYSQL table or any other database):
Save some data to the table. For example:
Before you save the data to the table, replace the \r\n
with <br>
:
Drag and drop GridView
from the Tool Kit to the Web form.
Create the following columns:
Gridview will appear like this:
Change the property of the Message column as shown below:
Set the HtmlEncode
to false
.
Write the code to fill the GridView
. Here is a sample:
The data will appear like this:
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
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