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


below query in storedprocedure(sql server 2008) return list of items table.

query:

select  ( coalesce(reviewdescription,'')+ replicate (' ', 20 - len(reviewdescription)) + '|' +  ( convert(varchar(100),reviewcharge))) reviewtypes reviewtype 

query result(copied text pad looking below):

sample review type    |200 

but after binding asp drop down control displaying below drop down display:

sample review type|200 

please 1 can on this.

thanks in advance...

it sounds browser collapsing whitespace. in html source see what's actually being sent down. can determine whether it's problem in display or data access.

(i'm not sure way of displaying pseudo-table in drop-down, honest.)


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -