wat is the best solution of getting values from the data base to the grid view.
-
iam having nearly 45000 records in the data base where iam getting these many records into the grid view using the select statement in the oracle query .the problem it is more time consuming .is there is any aleternate solution to get these many or more than these record as fast as possible
-
iam having nearly 45000 records in the data base where iam getting these many records into the grid view using the select statement in the oracle query .the problem it is more time consuming .is there is any aleternate solution to get these many or more than these record as fast as possible
Enable Pagination for the GridView. This would improve the performance of data loading
Castle Rider My: Website | Yahoo Group | Blog Spot
-
Enable Pagination for the GridView. This would improve the performance of data loading
Castle Rider My: Website | Yahoo Group | Blog Spot
hi mr rider to implement this also the data should come fast na .my problem is the data is not getting faster from the data base.
-
iam having nearly 45000 records in the data base where iam getting these many records into the grid view using the select statement in the oracle query .the problem it is more time consuming .is there is any aleternate solution to get these many or more than these record as fast as possible
You can enable pagination in your store procedure instead of code behind side. Suppose if you want to set PageSize=20,retrive only 20 records from database in one query and get total number of records in other query. There are many articles availabel.search in google for this. another way is that, retrive all records when page is loaded,store dataset in cockie and bind gridview and enable pagging. when page index changed,get back dataset from cockie and bind gridview.No need to retrive records from database again.
please don't forget to vote on the post that helped you.
-
You can enable pagination in your store procedure instead of code behind side. Suppose if you want to set PageSize=20,retrive only 20 records from database in one query and get total number of records in other query. There are many articles availabel.search in google for this. another way is that, retrive all records when page is loaded,store dataset in cockie and bind gridview and enable pagging. when page index changed,get back dataset from cockie and bind gridview.No need to retrive records from database again.
please don't forget to vote on the post that helped you.
hi sir the concept whic u are saying is quite intersting...plz help in this regrds by giving the best site abt paging in the database
-
You can enable pagination in your store procedure instead of code behind side. Suppose if you want to set PageSize=20,retrive only 20 records from database in one query and get total number of records in other query. There are many articles availabel.search in google for this. another way is that, retrive all records when page is loaded,store dataset in cockie and bind gridview and enable pagging. when page index changed,get back dataset from cockie and bind gridview.No need to retrive records from database again.
please don't forget to vote on the post that helped you.
Imran Khan Pathan wrote:
another way is that, retrive all records when page is loaded,store dataset in cockie
Are you kidding ? a dataset which contains 45000 records and keeping it in cookie ! I don't think it is possible.
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions
-
hi sir the concept whic u are saying is quite intersting...plz help in this regrds by giving the best site abt paging in the database
-
iam having nearly 45000 records in the data base where iam getting these many records into the grid view using the select statement in the oracle query .the problem it is more time consuming .is there is any aleternate solution to get these many or more than these record as fast as possible
R u used Stored Procedure. if not u might be use StroredProcedure , the command is still same but the stored procedure execute faster then simple command i hope this will help u....
-
iam having nearly 45000 records in the data base where iam getting these many records into the grid view using the select statement in the oracle query .the problem it is more time consuming .is there is any aleternate solution to get these many or more than these record as fast as possible
Hi U c try to pageing the data in database it self. Tanks Siva