Datagrid column format (only 10 leftmost characters) 1

[peekay]

I have a databound datagrid and wish to show only the leftmost 10 characters of a certain string field in a certain column. How would I do that ?
Thanks

PK Odendaal

http://www.odendaal.com

 

[JohnnyBGoode]

After you have done the DataBound(), you can loop through and replace the values of column X with the respective truncated values.

 

[adamroof]

i usually would change the sql statement...

SELECT tblID, Substring(tblText,1,10) AS halfString FROM tblStuff

That way, if you have Columns autogenerated, it would only load the 10 characters. Change the halfString to something more user friendly - AS 'My Field'

if you specify the columns, do HeaderText="My Field" DataField="halfString

 

[peekay]

JohnnyBGoode - I could not get your proposal to work.
adamroof - I had thought of your proposal before I posted the question, but could not get it right. However after I read your post and done some fiddling in which I substituted your substring() with mid() I got it to work correctly. Have a star.
This is a very interesting problem many people would have. Ultimately I settled for the solution that fetched the whole field and turned item wrapping off.
Thanks guys.

PK Odendaal

http://www.odendaal.com