hi,
i am using datagrid to display data, if one of my column data is much lenght(some 1000's of chars). this datagrid display total chars, But my aim is it display only 30 chars after that it display dots, (like our sqlserver if we execute select query, in that table columns contain more characters it display some characters after that it display dots) .
Please give a solution to do this.
Thanks.
Loading
CrishPosted May 12, 2010, 8:56 AM
use below statement in SQL stored procedure for binding limited character in Grid
case when LEN(Description) > 50 then substring(Description,0,45) + '...' Else Description End as NewsDescription
thanks
"Please mark "Yes" if this answer is useful for you"
ajay rajuPosted May 12, 2010, 9:24 AM