Hi
I have following problem. I have a big database table. I should to display this table using DataGrid. But, becouse the table so big is, it takes too much time.
I have following idea. I get from database and display only 50 records. When user navigates to the end of my small subset of records I will call a stored procedure to get the next 50 records. If user wants to see the last records I will get only 50 records from the end of my big table.
But this is only a pure idea... Supose I have a procedure:
public DataTable GetRecords(fromRecNo, toRecNo)
{
...
}
When and where shall I call this function? This must be something near DataGrid, I supose.
Do you have any idea?
May be do you know any other methotds of getting records to display without sending the whole table through the network?
Thanks!
I have following problem. I have a big database table. I should to display this table using DataGrid. But, becouse the table so big is, it takes too much time.
I have following idea. I get from database and display only 50 records. When user navigates to the end of my small subset of records I will call a stored procedure to get the next 50 records. If user wants to see the last records I will get only 50 records from the end of my big table.
But this is only a pure idea... Supose I have a procedure:
public DataTable GetRecords(fromRecNo, toRecNo)
{
...
}
When and where shall I call this function? This must be something near DataGrid, I supose.
Do you have any idea?
May be do you know any other methotds of getting records to display without sending the whole table through the network?
Thanks!