Somewhere it is showing that we can pass variables in custome application page then how.. pls share the proper link that how can i pass parameters from one aspx...

will any one help me on that pls

Yes.. i tried many times before writing this question.. but no luck.. that is why i have pasted my query here

I did the same but that is not working..

can you tell me your SQL server version ?

Datatype of this column nvarchar or varchar or something else ?

Regards,

Krishna

Hi Sashi,

Please find below query for this.. this is so simple query..

SELECT houseno

FROM test

order by houseno