Solved

limit character length in gridview cell

Posted on 2008-11-03
5
2,253 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
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 125 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

773 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