c# - Populating a SelectList from a DataTable

Question

I ran a query and returned a datatable,

myDataAdapter.Fill(myDataTable);

Now what is the best way to load the row values "Value" and "Text" into a SelectList?

Thanks

Answer 1

I couldn't find a way to directly bind the DataTable to a SelectList so I resolved creating an Extension method to accomplish this:

public static SelectList ToSelectList(this DataTable table, string valueField, string textField)
{
    List<SelectListItem> list = new List<SelectListItem>();

    foreach (DataRow row in table.Rows)
    {
        list.Add(new SelectListItem() 
        {
            Text = row[textField].ToString(), 
            Value = row[valueField].ToString()
        });
    }

    return new SelectList(list, "Value", "Text");
}