How to navigate in record?

Gaurav Bhatia · **Joined:** Sat Apr 21, 2007 2:12 am **Posts:** 16

Hi

I have four buttons on my window. Next, Previous, Last, First...On clicking on each of them, I want to navigate in record. For example if I click on Next, next record should be fetched and if Last is clicked , Last record should be fetched and its corresponding values should be shown in corresponding controls like textbox etc. But I am not able to do this through Nhibernate. Please help me.

Thanks

Gaurav

Gaurav Bhatia · **Joined:** Sat Apr 21, 2007 2:12 am **Posts:** 16

I am still searching for solution. Please help.

Gortok · **Joined:** Sun Jan 21, 2007 4:33 pm **Posts:** 65

If IDs are stored by Integer, simply start at 1 (First Record Button), and Have the 'next' increase the integer by one, and issue another Get<> when that happens. I dunno exactly how to grab the last record, besides using straight ADO.NET.

Gaurav Bhatia · **Joined:** Sat Apr 21, 2007 2:12 am **Posts:** 16

Hi Gortok
Thanks for your reply.
Well the problem has been solved. It needs only this much code

ISession session = null;
session = DbFactory.NHSession;

IList companies = session.CreateQuery(" FROM Customer ").List();
this.customerBindingSource.DataSource = companies;

this.customerBindingSource.MoveNext();
or anything you want to do...next, last previous.

This code will be written after binding controls with presistent class.

Thanks

Gortok · **Joined:** Sun Jan 21, 2007 4:33 pm **Posts:** 65

Gaurav Bhatia wrote:

Hi Gortok
Thanks for your reply.
Well the problem has been solved. It needs only this much code

ISession session = null;
session = DbFactory.NHSession;

IList companies = session.CreateQuery(" FROM Customer ").List();
this.customerBindingSource.DataSource = companies;

this.customerBindingSource.MoveNext();
or anything you want to do...next, last previous.

This code will be written after binding controls with presistent class.

Thanks

... I forgot about that...

Damn.