How would I populate a DropDownList's value and text fields with information in a DataTable?

Question

How would I populate a `DropDownList's` value and text fields with information in a DataTable? Example DataTable ``` Employees : EmployeeID, Name ``` I tried... ``` EmployeeDropDownList.DataTextField = Employees.NameColumn EmployeeDropDownList.DataValueField = Employees.EmployeeIDColumn EmployeeDropDownList.DataBind() ``` The two assignment lines are invalid though because it's not the correct datatype.

Accepted Answer

```
EmployeeDropDownList.DataSource=Employees.DefaultView
EmployeeDropDownList.DataTextField = "Name"
EmployeeDropDownList.DataValueField = "EmployeeID"
EmployeeDropDownList.DataBind()
```

How would I populate a DropDownList's value and text fields with information in a DataTable?

Solution

Problem