how to bind two column values in dropdown list in gridview

Question

my table has three columns productidproductnameprice In dropdownlist i want display all productname-price from database. in dropdown i need like this below iphone-15000 oneplus-2000 all in gridview column.(front end)

Joginder Banger · Answer

I made for you a simple query in sql. I hope it will be help you. create table #Temptable (productid int productname varchar ( max )price int ) insert into #Temptable values (1 'iphone' 1500) insert into #Temptable values (1 'oneplus' 2000) select productid(productname+ '-' + cast (price as VARCHAR )) as Model from #Temptable Output: productid Model 1 iphone-1500 1 oneplus-2000