How Do I Limit Charcter Length Of Dropdown;S Text Field To 20 Charcter ?

Question

0.00/5 (No votes)

See more:

Hii ,

What i want to do is ... the text field of dropdown , i just i want to limit the string ..

if the text is more than 20 then it should be

"df gfgf hf hgh.."

Please suggets

Posted 22-Dec-14 0:42am

Torakami

Add a Solution

Comments

Sibasisjena 22-Dec-14 6:46am

Hi Torakami,

How are you binding the dropdownlist. In C#?

Praveen Kumar Upadhyay 22-Dec-14 7:13am

You just need to set the width of the Dropdown. But if you want to wrap the text with .... then better you do it with the sql query itself.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

psima · Answer 1 · 2014-12-22T01:28:00

or you can manage it in query and then display :-
Here is List of customers:-

SELECT CNAME FROM dbo.CUSTOMER   

CNUM	CNAME
2001	HOFFMAN
2003	LIU
2004	GRASS
2005	CLAMERS
2006	CINUS
2007	PERERIA
2008	LIU

Here in this example, I will show only first 5 characters of Customer Name :-

SELECT CNUM,CASE WHEN LEN(CNAME) > 5 THEN SUBSTRING(CNAME,0,6) + '..' ELSE CNAME END CNAME  FROM dbo.CUSTOMER 

CNUM	CNAME
2001	HOFFM..
2003	LIU
2004	GRASS
2005	CLAME..
2006	CINUS
2007	PERER..
2008	LIU