CODEWITHSUNDEEP
c#asp.net-3.5sql-server-2008-r2
VInayK
VInayK

Reputation: 1559

Concatenated string column is not displaying properly in dropdown list(asp.net)

Below is my query which is in Storedprocedure(SQL Server 2008) will return list of items from a table.

Query:

SELECT 
( COALESCE(ReviewDescription,'')+ REPLICATE (' ', 20 - LEN(ReviewDescription))
+ '|' + 
( CONVERT(VARCHAR(100),ReviewCharge))) AS ReviewTypes
FROM ReviewType

query result(copied to text pad then its looking like below):

Sample review type    |200

But after binding to ASP drop down control it is displaying like below drop down display:

Sample review type|200

Please some one can help on this.

Thanks in advance...

Upvotes: 1

Views: 151

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1502036

It sounds like it could well just be the browser collapsing whitespace. Look in the HTML source to see what's actually being sent down. Then you can determine whether it's a problem in the display or the data access.

(I'm not sure this is really a good way of displaying a pseudo-table in a drop-down, to be honest.)

Upvotes: 2

Related Questions