How could i bind 3 columns in dropdown list in asp.net

Hi,

 

There are couple of way you can achieve this. one way you can do from code you can concatinate multiple coulmn and create DataTextFiled and other way you can bring multiple column from sql Query as single column as DataTextField,

 

Please find below links, 

 

https://forums.asp.net/t/1809575.aspx?How+to+bind+3+columns+to+a+dropdownlist 

https://forums.asp.net/t/1088821.aspx?Bind+multiple+columns+to+DropDown+List+DataTextField+ 

https://stackoverflow.com/questions/16206993/binding-3-values-to-dropdown-list