So what is your problem over there ?
Looks just fine to me.
These is a tedious approach unless one wants custom solution.
Follow below for less coding
a) Fill
DataTable
using
DataAdapter
.
b) Assigin
dropdownlist
DataSource
to that
DataTable
.
c) Set
DataSource
of
Dropdown
.
d) Set
DataValue
of
<code>
DropDown.
See
THIS[
^] for more.