Just specify columns in DataTextField and DataValueField like this:
sptestreqtestnameddl.DataTextField = "test_name"
sptestreqtestnameddl.DataValueField = "test_id"
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com