I would like to achieve this with Datagrid.

I have a datagrid with a table and set of columns.

The dataset I dynamically generate may contain 10000 through 1000000 rows.

I wanted to populate 100 rows first, and when the user navigates to 100th row
and then goes next record, i wanted to populate or add next 100 rows to the datagrid
and so on like this. I also have a scroller. If the user uses to scroller to reach
the bottom of the first 100 rows, I wanted to add or populate next 100 rows.

I know how to fetch 100 rows from my query, but do not know the event that fires
at the end of datagrid row or the scrollbar event

What event of the datagrid or scroll bar should I write my next 100 row fetch.

Any help is appreciated very much.

Thanks in advance.

Jil

Experts!, Help Please.