problem in showing number data in dropdownlist

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Apr 30, 2014 03:32 AM
Forum: Data Controls
Answer: 1
Views: 2467

I have estate_p table that contain zone column this column datatype is Varvhar(5) and in this column save below data

1 2 3 4 5 6 7 8 9 10 11 12 13

I bind DDlZOne from this column and in SP I define order by zone asc

but in ddl show above number like below:

1 10 11 12 13 2 3 4 5 6 7 8 9

how I can solve these problem I don't want change zone data type to int becuse I want save data in string in this column ...

Best Regards

Neda

Azim

0 12

Reply
ANSWER
User: Azim
Replied: on May 05, 2014 07:45 AM
Report

You need to give Alias name as Zone

ALTER procedure [dbo].[GuidregionE]
	@Behcode NVARCHAR(10)
	,@type NVARCHAR(20)
	,@transfer NVARCHAR(20)
	,@measure NVARCHAR(30)
AS
BEGIN

	SELECT DISTINCT CAST(zone AS INT) AS Zone
	FROM Estate_p
	WHERE (behcode=@Behcode) 
		AND (Type = @Type OR @Type = 'all')
		AND (Transfer = @Transfer OR @Transfer = 'all')
		AND (metraj = @measure OR @measure = 'all')
	ORDER BY CAST(zone AS INT) ASC 
END

problem in showing number data in dropdownlist

Company

Explore

Follow us

Contact Us