Hi Friends I need sql table column values to display in this format

See more:

SQL-Server-2005

C#2.0

C#

, +

I have a table Employee with column name as Employee_Id,Employee_Name....In that table i have following values
Employee_Id Employee_Name
EMP_01 A

EMP_10           J
EMP_11           K
EMP_12           L
EMP_13           M
EMP_02           B
EMP_03           c
EMP_04           D
EMP_05           E
EMP_06           F
EMP_07           G
EMP_08           H
EMP_09           I

I need to bind Employee ID in DropDown ....Employee Id is not in continuous after 1 ...11 is coming in sql table....After binding i need EMP_1,2,3,4,...