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" />
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?
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.
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.
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?
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:
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; }
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 ?
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.
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.
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.
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:
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.
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.
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).
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 }
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
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.
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 .
