Loading

how to bind two column values in dropdown list in gridview

Mohan Srinivas

my table has three columns productid,productname,price

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)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger9y ago
Accepted 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
+1