By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,857 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,857 IT Pros & Developers. It's quick & easy.

Gridview Show Columns help

P: 9
I have a column "description" in a sql table. it contains 2000 characters.

I would like to setup my gridview column "Description" to show
the first 30 characters only.

At the moment it shows all the characters.

Is there and option for this in Edit Columns, under GridView Tasks???
Aug 8 '07 #1
Share this Question
Share on Google+
2 Replies


dip_developer
Expert 100+
P: 648
I have a column "description" in a sql table. it contains 2000 characters.

I would like to setup my gridview column "Description" to show
the first 30 characters only.

At the moment it shows all the characters.

Is there and option for this in Edit Columns, under GridView Tasks???
you can split 30 characters from description field while selecting....

make your sql like that...

SELECT SUBSTRING(description , 0, 29) AS desc FROM myTable
Aug 8 '07 #2

P: 9
Okay! i didn't know that !!! :)
I will do that.
thank you so much, and have a nice day :)
Aug 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.