ddSegID.DataTextField = "SEG_NM"

Im binding my dropdown list textfield to a a row from my datasource, what i dont know how to do is add a string which contains another field and a "-".

I tried

ddSegID.DataTextField = ("SEG_ID" + " - " + "SEG_NM")

but it doenst work

in your SQL statement you could do:

Select SEG_ID + ' - ' + SEG_NM as ConcatField From .......

Then

ddSegID.DataTextField = ("ConcatField")

Quote:

---

Originally Posted by rdove

in your SQL statement you could do:

Select SEG_ID + ' - ' + SEG_NM as ConcatField From .......

Then

ddSegID.DataTextField = ("ConcatField")

---

Thanks RDove someone already suggested this and i amended my stored procedure.

Cheers