I'm a beginner. Please help me with IQuery

senorali33 · **Joined:** Sun Dec 24, 2006 1:16 am **Posts:** 2

Hi all !
I have a NHibernate question and really need your help.
i have 2 tables with one-to-many relation like this :
-tblCategories with these fields:
catID int primary key ( reference category field of tblItems)
catName nvachar(30);
catDesc nvarchar(100);
-tblItems with fields
itemID int primary key
category int
itemName nvarchar(50);
itemPrice double;
Now i create a IQuery like this
IQuery q=session.CreateQuery("Select item.ItemID,item.Name,item.Price
from Item as item,Categories as cat
where item.Category.catID = cat.catID and
cat.ID=:_inputID ");
This query executes OK but the problem is that i don't know how to get the result as the datasource
of a datagrid ( for example ). Can anyone help me???. I need it very much.
Thanks in advance
Merry chrismas and happy new year!!!

martijnb · **Joined:** Sat May 14, 2005 8:40 am **Posts:** 130

senorali33 wrote:

Code:

IQuery q=session.CreateQuery("Select item.ItemID,item.Name,item.Price from Item as item,Categories as cat where item.Category.catID = cat.catID and cat.ID=:_inputID ");

This query will return an IList with object arrays that are not so easy to bind. What you need is a query that just returns the complete Item objects:

Code:

IQuery q=session.CreateQuery("select i from Item as i, Categories as cat where i.Category.catID = cat.catID and cat.ID=:_inputID ");

senorali33 · **Joined:** Sun Dec 24, 2006 1:16 am **Posts:** 2

thanks for your help but can you show me an example to bind the result with a gridview. sorry if this question is stupid. I'm a beginner.
Best regards!