how to show large table to viewers???
-
Hello, everyone: I am a newbie of asp.net. Now i am trying to use a datagrid to show a table with more than 2000 records to the web viewer with asp.net1.1. However, when displaying, it tells me that the process has taken more than 60% of the memory, the system calls back the resouce automatically. Finally the pages goes wrong. In one word, What i am asking is whether there is a good approach to displaying a large table to the user? Is there anyone could help me? Thanks in advance!:rose:
-
Hello, everyone: I am a newbie of asp.net. Now i am trying to use a datagrid to show a table with more than 2000 records to the web viewer with asp.net1.1. However, when displaying, it tells me that the process has taken more than 60% of the memory, the system calls back the resouce automatically. Finally the pages goes wrong. In one word, What i am asking is whether there is a good approach to displaying a large table to the user? Is there anyone could help me? Thanks in advance!:rose:
-
You can use paging concept. There you will just show 25 or 50 records initially and then next set of records depending upon the requirement.
Best Regards, Apurva Kaushal
First of all, great thanks to u of replying!:rose: However, i have to store query result in a datatable so that i could print or export these results latter. It is these query resutls that has taken out the resource, i think. Look forward to you further replying...;P
-
First of all, great thanks to u of replying!:rose: However, i have to store query result in a datatable so that i could print or export these results latter. It is these query resutls that has taken out the resource, i think. Look forward to you further replying...;P
If it is required to get all the records in one stretch then also you can get the advantage of datagrid paging. What you need to do is to get the data in dataset and then assign it to the datagrid with paging enabled. Also the same you can have in the datatable. I hope i am understanding you problem correctly.
Best Regards, Apurva Kaushal
-
Hello, everyone: I am a newbie of asp.net. Now i am trying to use a datagrid to show a table with more than 2000 records to the web viewer with asp.net1.1. However, when displaying, it tells me that the process has taken more than 60% of the memory, the system calls back the resouce automatically. Finally the pages goes wrong. In one word, What i am asking is whether there is a good approach to displaying a large table to the user? Is there anyone could help me? Thanks in advance!:rose:
See an example about datagrid paging at : http://www.programmingknowledge.com/datagridpaging.aspx[^] postmaster