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.