I was having a little trouble figuring out how to select only distinct values from a column and populate a dropdownlist using SubSonic and ASP.NET 2.0 C#. Here is my solution:

SubSonic.Query q = new SubSonic.Query("Projects");

            q.QueryType = SubSonic.QueryType.Select;

            q.DISTINCT();

            q.SelectList = "ClientName";

            q.ORDER_BY("ClientName");

            DropDown1.DataSource = q.ExecuteReader();

            DropDown1.DataTextField = "ClientName";

            DropDown1.DataBind();

If you are getting "System.Data.DataRowView" when binding the SubSonic DropDown control programmatically, be sure to check if you set the DataTextField property of the DropDown control to the correct column name.