ddSegID.DataTextField = "SEG_NM"

[davebat]

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

[rdove]

in your SQL statement you could do:

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

Then

ddSegID.DataTextField = ("ConcatField")

[davebat]

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