Hi Fellas,
Situation:
1. In your database table i.e customertable have 500 records/rows.
2. A datagrid in a form can shows 100 visible of rows.
"Since the datagrid can show 100 visible rows i will just query select top 100 from customertable"
Question:
If I scroll down the scrollbar of a datagrid let's say scrolling until 3/4 of the scroll area (let's say in scrolling 3/4 of the area the equivalent rows in the database will be from the row 300 to 400), so the records to be shown in the datagrid must be the 100 rows from the row 300 to 400.
my question is how to do that trick, can anyone of you guys know about how to do it? Right now I'm completely zero idea where to statrt.