Data Controls :: Gridview Paging Is Taking Some Time (15-20 Seconds) To Go To Next Page
May 7, 2015
I had implemented the Ajax timer control to update Gridview data(along with Progress bar inside Gridview) after some interval of time.Below is the full code:
HMTL:
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<%--style & Script for progress bar in Gridview --%>
<script type="text/javascript" src="//code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript" src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<link href="css/jquery-ui.css" rel="stylesheet" />
[Code] ....
C#:
protected void Page_Load(object sender, EventArgs e) {
if (!this.IsPostBack) {
BindGrid();
} }
protected void BindGrid() {
string query = "SELECT * FROM Table";
[Code] ....
It is working fine except that the Gridview paging is taking some time(15-20 seconds) to go to next page.
View 1 Replies
Similar Messages:
Mar 26, 2011
I am using grid view with row "data bound event" at row row data bound i am using some function with loops to fill drop down of grid view in template columns. grid view gets populated with selected index change event of drop down. my problem is the asp.net page is getting slower i mean when grid populates its taking some time and some time page get hanged what to do to get rid of it?
View 1 Replies
Jan 13, 2010
I am making some application in asp.net 1.1 in that I am displaying data in datagrid from database. In data grid first column is of check box and radio button and in the last column we have text box now thing is that when i click on check box crosponding textbox we fill some figure and at the end we press calculate button to get total. After getting total we have to press continue button to go next step
But suppose if some body remove that check the we should press calculate button or chnage some figure in the text box then we should press calculate button again to recalculate. for that i kept autopost back on check box oncheckedchanged event and text box ontextchanged event and hide continue button so user will click calcutae button abd then continue button will re-apper
Problem it that it taking too much refresh and taking long time. So was lloking for some ajax method to use in my application.
View 8 Replies
Mar 24, 2010
I have Gridview control with all rows are edit mode using Itemtemplate and footer template. Some of columns are having ajax calendor control.
Page is very slow. If I am loading 500 rows into GridView
View 4 Replies
Feb 12, 2011
[Code]....
I am retrieving records from database nearly 380 records and binding them to a repeater control.My page is taking long time to load. how to improve the performance and here is the code of my repeater.
View 1 Replies
Oct 14, 2010
I do long and slow query to get data to my GridView and I got lot of data, but when I'm changing page it loads as slow as at the start, it loads full data again and again, how to load data once and use paging without data loading?
View 1 Replies
Mar 4, 2010
I'm doing a web request that is too slow. It takes around 3.2 seconds to GetResponseStream() and .8 seconds to ReadToEnd() If I run the same request in a web browser I get a response in less than a second... I'm wondering what I can do to speed up the request and what might cause it to be slow? Based on other questions I saw here, I disabled the proxy in app.config + enabled max connections, just in case (it's still slow). The section I added was:
<system.net>
<defaultProxy enabled="false">
<proxy/>
<bypasslist/>
<module/>
</defaultProxy>
<connectionManagement>
<add address="*" maxconnection="65000" />
</connectionManagement>
Here's a screenshot of what the code looks like and what is slow:
View 1 Replies
Oct 29, 2010
I am having a Gridview which takes much time to load its data, I tried to make the loading faster by implementing paging in gridview and reducing the rows to render in the grid and it got worked to an extent but still it lags in processing to bind data. The database i am using is SQL Server 2005 and the code is as follows
DataTable dtProducts = objProducts.GetProductDetails(iCat.ToString(), userId);
dgrdProductList.DataSource = dtProducts;
dgrdProductList.DataBind();
public DataTable GetProductDetails(String CatID, String UserID)
{
DataAccess DAB = new DataAccess();
DataTable dtbProducts = new DataTable();
try
{
string SQL = "select *,CAST(ShortDescription AS varchar(200)) AS ShortDescriptionList from vw_products where IsActive=1 AND CategoryID = " + CatID +
" AND LanguageID in( SELECT PW_UserLangRel.LanguageID FROM PW_Language INNER JOIN " +
" PW_UserLangRel ON PW_Language.ID = PW_UserLangRel.LanguageID WHERE PW_Language.IsActive=1 AND PW_UserLangRel.CompanyID=" + UserID +
" ) Order By ID Desc,LanguageID";
dtbProducts = DAB.Fill(SQL, CommandType.Text).Tables[0];
}
catch (Exception ex)
{
throw new Exception(ex.Message + "WebShopPaolo.CProducts.AddProductImages");
}
return dtbProducts;
}
View 1 Replies
Feb 20, 2010
I have an application which imports data from csv to sql server 2005. It is taking long time to import data from csv to sql server 2005. it has a timer. on tick of timer, I am checking if current rown in csv exists in database. If it exists, It is not added to sql server otherwise, It is added that row to sql server 2005. Also, In page load, It checks on each tick, whether user is logged in or not. it adds value to log file that user is logged in. How can I optimize this ?
View 1 Replies
Apr 20, 2010
The home page of my website and some other page also are taking some time to load, instead of making them load fast, I want some please wait screen or progress bar and mean while the required page would be loaded behind.
View 3 Replies
Mar 6, 2010
I have web application where i want to show pdf files in web page. in my page there are 5 pdf files i have to show at a time.it's taking much time to load page. and also user has to wait until all files are loaded in page.is there any free components to show pdf files.
View 3 Replies
Nov 22, 2015
I have a big form in which i have almost 10 update panels. some are having updatemode = conditional and others are always. Now by default when that page is opened i only show one dropdownlist.When that project dropdownlist (from which i populate the rest of the elements in my page) value is changed by user it takes long time to load the other elements. Also the other gridview which is also surrounded by update panel and mode in conditional takes long time to show edititemtemplate controls in edit mode.
I am unable to trace the reason behing delay. Few days ago it was working fine and fast but now it is slow.
View 1 Replies
Jan 4, 2011
I have a Gridview all setup and even though I have the paging working it takes select the page twice in order to switch the page. Basically my code is as follows:
[Code]....
View 2 Replies
Nov 18, 2010
Is there a way to use the GridView paging and having the links not use JavaScript. So that when you click on the page number 5 (for example) that link is a hyperlink.
View 3 Replies
Dec 30, 2010
I want to display the paging format like 1 2 3 4 5 ....... 20 in gridview pagnation
here total number of pages count is 20.
if user clicks on the 20,then the page no 20 will be display..
and the user cilcks on .....,the next five pages has to display with last page number like 6 7 8 9 10 ....... 20
View 3 Replies
Jan 12, 2011
So my problem is as followes:
i have a gridview in another gridview (gv2 inside gv1).
in codebehind, at pageload i have: [Code]....
witch gives me a number of total records in the gv2 to a label. something like a coment number label.
my problem occures when i press the page button (allowpaging = true) on the first gridview. it acts kinda like this:
it makes the second gridview.visible = true; doest string the number of rows, and the label.text = "";
i've tried to make a code like this:
if (Ispostback)
{
gridview1.databind();
foreach ...etc..
}
else
{
foreach ....etc...
}
Also the gridview 1 and 2 the datasource is an SqlDataSource.
but that didnt work . also tried some things in pageindexchanged and pageindexchanging but still no efect :(. and also tried with enableviewstate = false / true on both gridviews with diferent combinations, but still no luck.
the code works only when i have allowpaging = false, or when im on the first page of the gridview (for the first time) is that the number of coments is pasted into the label.
View 3 Replies
Feb 10, 2011
I have a two webpages,in my first webpage i have gridview with 8 pages(paging) and four coloumns.In fourth coloumn i have a link button to redirect tosecond webpage ,now i am in gridview 4 th page(paging) then i clicked the link button and move to second
second webpage.
second webpage contain one button that will redirect to first webpage.if i come from second webpage to first webpage the gridview paging get reset.but i want to be on gridview 4th page(paging).
View 10 Replies
Jan 3, 2010
is there any way how to highlight the actual number of page where I am ? .... somethink like this: < 1 2 3 4 5
6 7 8 >
View 3 Replies
Feb 26, 2010
I'm trying to set paging on my gridview but when i click on a page it doesn't work. It return a blank page. Here's my code:
[Code]....
Behind code:
[Code]....
View 9 Replies
Oct 9, 2013
I currently have a GridView control on my aspx page with paging enabled and I need to loop through the entire row collection/count to process the selected records. With my current code, it will only loop through the current page of GridView row.
foreach (GridViewRow data in grid.Rows)
{
//here is my code
}
View 1 Replies
Feb 25, 2016
[URL]
using above code i am able to print gridview directly without hidden fields.after added to hiddenfields to gridview , hiddenfield values are visible for printing.after i am using gridview.colums[i].visible=false column not visible while printingproblem is after print the gridview not visible whatever my columns set visible false.Example:at printing time i am set checkbox visible false, after printing i want reload same page with checkbox but check box not visible after printing gridview
View 1 Replies
Jun 29, 2010
I'm using data access block [URL] in asp.net 3.5. Back end is sql server 2005. It's working fine and returns result instantly for all DB calls. But, I've a problem with one SP. When I call it, executereader is taking too much time. In few cases, it is executed. And sometimes I get the Time out error. I run the same SP in sql server. It returns 9000 rows in 3 seconds.
View 3 Replies
Aug 25, 2010
Issue:
As my pages are taking time to load first time.
So user has to wait till full page gets loaded and thats irritating . Was this the reason MVC was evolved?
Solution :Should i use partial rendering on all pages including home page, and all forms getting called from home page.
So even if half page is loaded thats less frustrating
For Partial rendering what i plan is : i will put Scriptmanager with Enable partial renderingand update panel for half part of page.
So that user dont have to wait for full page to load.
Is my plan correct? Problem is i cannot regenerate page load issue every time.
View 4 Replies
Mar 2, 2011
I want to create a gridview with checkboxes. (only vb.net)
1) persist checkbox rows in paging in vb.net not c#
2) add the checked rows to datatable datasource and show on next page in paging
View 2 Replies
Dec 5, 2010
when i am runnig the project, the crystal report(rpt) file will taking too much time for loading on first time... any one please help me to avoid the time delay for loading the rpt file in first time .
View 2 Replies