Create a dropdownlist using ActiveRecord

Question

I have a table called ProjectRegion. It has two columns, an id and a title. I successfully use ActiveRecord to get all the rows. I want to create a drop down list where I assign the id column to the value and the title to the text. I suspect I'll be able to do something like-

ProjectRegion[] projRegion = ProjectRegion.FindAll();
DropDownList1.DataTextField = ???;
DropDownList1.DataValueField = ???;
DropDownList1.DataBind();

But I don't know the syntax?

Answer 1

Maybe what you need is:

DropDownList1.DataSource = ProjectRegion.FindAll();
DropDownList1.DataTextField = "title";
DropDownList1.DataValueField = "id";
DropDownList1.DataBind();

The values for DataTextField and DataValueField are just strings referencing the properties of your ProjectRegion class.