?
Solved

limit character length in gridview cell

Posted on 2008-11-03
5
Medium Priority
?
2,425 Views
Last Modified: 2009-04-13
I have a field in the database that have up to 1000 characters in it.  In my gridview I only want to show the first 100 characters in that column, but when they click the view/edit link then it will show all the text.

Does anyone have a simple way of doing this?  Thanks.
0
Comment
Question by:andy12279
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 22867570
Perhaps this example can help you: Dynamic Gridview - Adding a max length to the edit textbox
http://forums.asp.net/t/1233788.aspx
0
 
LVL 26

Accepted Solution

by:
Anurag Thakur earned 500 total points
ID: 22869553
quite simple
add a template filed for description and code as shown belwo
<asp:TemplateField ItemStyle-HorizontalAlign="left" ItemStyle-Width="170px" HeaderText="Description" >
	<ItemTemplate>
		<%# Eval ("Description").ToString ().Length > 100 ? Eval ("Description").ToString ().Substring (0, 100) + "&" : Eval("Description").ToString ()%>
	</ItemTemplate>
</asp:TemplateField>

Open in new window

0
 
LVL 22

Expert Comment

by:prairiedog
ID: 22890716
Even simpler:
<asp:TemplateField ItemStyle-HorizontalAlign="left" ItemStyle-Width="170px" HeaderText="Description" >
	<ItemTemplate>
		<%# Eval ("Description").ToString ().Substring (0, 100)%>
	</ItemTemplate>
</asp:TemplateField>

Open in new window

0
 
LVL 2

Author Comment

by:andy12279
ID: 22890738
Yes prairidog that will work but if the string is less than 100 characters it will throw an error.
0
 
LVL 22

Expert Comment

by:prairiedog
ID: 22890788
Really? I thought it will just ignore the second parameter if the length is less than 100. Well, I was wrong.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question