ISQLQuery query;
            string sql = "SELECT t.* " +
                         "FROM CompanyTheme ct, Theme t " +
                         "WHERE ct.ThemeID = t.ThemeID AND ct.CompanyID = :companyID";

            query = Session.CreateSQLQuery(sql)
                .AddScalar("ThemeID", NHibernateUtil.Int32)
                .AddScalar("Name", NHibernateUtil.String)
                .AddScalar("Folder", NHibernateUtil.String);

IList results = query.SetInt32("companyID", companyID).List();

ddl.DataTextField = ;
ddl.DataValueField = ;
ddl.DataSource = results;

foreach (object[] row in results)
        {
            ddl.Items.Add(new ListItem(row[1].ToString(), row[2].ToString()));
        }