I'm trying to return a list of dicussion title along with their number of replies, and bind to a datalist

IList imgIL = session.CreateSQLQuery(@"select count(*) as Dem,
img_album_name as Imgalbumname,
u.usr_username as Usrusername
from vnt_images i join vnt_image_albums al
on i.img_album_id = al.img_album_id
join vnt_users u on al.img_album_by = u.usr_id
group by i.img_album_id, al.img_album_name, u.usr_username
order by count(*) desc ")
.AddScalar("Dem", NHibernateUtil.Int32)
.AddScalar("Imgalbumname", NHibernateUtil.String)
.AddScalar("Usrusername", NHibernateUtil.String)
.SetMaxResults(6).List();

datalist1.DataSource = result;
datalist1.DataBind();

<asp:Datalist ID="datalist1" runat="server">
<ItemTemplate>
<%#Eval("Imgalbumname")%><br/>
<%#Eval("Usrusername")%>
</ItemTemplate>
</asp:Datalist >


The problem is <%#Eval("Imgalbumname")%>, <%#Eval("Usrusername")%> is not recongizable. I get an error

'System.Object[]' does not contain a property with the name 'Imgalbumname', 'Usrusername'

Anybody can help me out on this? How do I retrive the column values? Thanks

You're query returns an array of objects[]:

object[] { dem, Imgalbumname, usrusername }

for each line of the result set. You need entities for a proper databinding. Try the AliasToBean result set transformer:

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html#d0e9192

Thanks for replying and answering my question. It's done