linq query to populate DDL

Question

I need immediate help. I have to create a class in asp.net 3.5. This class will take a dataset as input and have method in it that will populate dropdown list. The dataset has 5 columns. Based on column name passed as parameter to this method, the dropdown list will be populated with data in that column. Please add linq query to this method.

Please help me with linq query code ASAP.

region Public Methods

public DataSet DDLPopulate(String columnName)
{
    DataSet DSToReturn = new DataSet();
    //logic to filter based on the column NAme  - LINQ Query
    return DSToReturn;
}

Answer 1

This might help you more. LINQ to DataSet Examples

Answer 2

Why go thru the effort of Linq2SQL, when you can simply use a DataAdapter?

Answer 3

You should've looked the examples in LINQ 101.

Anyways here's your query:

dropDownList.DataSource = from c in YourDataSet.Table.AsEnumerable()
                             select c.Field<string>("columnName");
dropDownList.DataBind();

Notice that the field type should be specified. So you should take care of that too.