Hi all,
can someone help me how to paging query result using Criteria and Sql 2K ( not SQL 2K5 ) ?
Can someone post a sample of doing it?
Thanks in advance,
Simone

you could try this:

DetachedCriteria pagedQuery = DetachedCriteria.For<Entity>()
.SetMaxResults(pageSize)
.SetFirstResult(pageSize*pageIndex);

DetachedCriteria countQuery = DetachedCriteria.For<Entity>()
.SetProjection(Projections.Count());

var result = session.CreateMultiCritieria()
.Add(pagedQuery)
.Add(countQuery)
.List();

var items = result[0];
var count = (long)result[1];

are you sure with this ?

Because DetachedCriteria does'nt contain SetMaxResults / SetFirstResult Methods.

And There is not usage with CreateMultiCritieria

We use our own modified MS SQL 2000 dialect for this so that standard setmaxresult and setfirstresult work. Dialect makes use of triple sorting trick and works pretty well. If you like, I can make the source of the dialect downloadable.