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
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.
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.
i know how do the paging with normal return query using row number in sql server, but i'm looking how to do the paging , sql server full text search returning result.
Can i use the same row number function or any good perfomance way?
whcih sql server full text search(FREETEXT,CONTAINS and etc) is best article site?
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 RepliesI am trying to create a Question Bank application for one of our clients. What is the main challenge I am facing is a typical demand from the client. What they want is : Whenever users open this site a set of random numbers(range say 1 to 20) should be generated and questions with the QuestionID(column in a table in Database) according to the numbers would be displayed in the page. I have done it to some extent but, still not satisfied with it.
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
int[] n = new int[10];
int rn;
bool Check = true;
int[] n1 = new int[10];
Random rand = new Random();
n1[0] = rand.Next(1, 21);
for (int i = 1; i < 10; i++)
{
rn = rand.Next(1, 21);
for (int j = 0; j < n1.Length; j++)
{
if (n1[j] == rn)
{
Check = false;
break;
}
else
continue;
}
if (Check == true)
n1[i] = rn;
}
for(int i=0;i<10;i++)
Response.Write(n1[i] + " ");
}
}
Here are some O/Ps : 11 13 14 4 16 0 0 0 0 0 (1st load)
5 9 8 1 0 0 0 0 0 0 (after refreshing the page)
16 10 20 6 8 17 11 7 0 0 (after refreshing again)
I want that, all these digits in each refresh should be unique(which is comming) but all set should 10 digits(this is not happening).
I think the title says it all, I have an activeX control, that ask the user if he want's to install it every single time the page loads (Even if it is already installed). Can anyone point me in the right direction? What I have tried so far:
Setting new Guids for the class & interface.
Changing interfaces names & method names.
Changing version number
Uninstalling and re-installing the activeX
I have the following code in my aspx file
<asp:DropDownList id="lstBannerType" runat="server" CssClass="input_nosize" AutoPostBack="True" OnSelectedIndexChanged="lstBannerType_SelectedIndexChanged">
<asp:ListItem>Top banner</asp:ListItem>
<asp:ListItem>Tower banner</asp:ListItem[code]....
but want to change this so it loads in my aspx.cs page so I can wrap it in an id (!IsPostBack) statement to stop the value getting set back to Top banner when the page is refreshed
My page includes a button and a GridView bound to a LINQ data object which is bound to a table. when the page loads the gridview gets populated with the data and all work well. The button has an empty method, when I click the button I get en error message "Intenet explorer cannot display the web page" I put a break point at the begining of the method listed below but I get the error message before it gets there. If I remove the gridview than the button works well.
[Code]....
I have two grids "grid1" and "grid2" and two updatePanels "up1" and "up2". Both the panels have UpdateMode = "Conditional" grid1 is nested in up1 and grid2 is nested in up2 [Code]....
In Code behind : [Code]....
I am using UpdatePanels, but still data will be fetched whenever page loads. How can I handle so the dat will be fetched on ony for the grid which is being updated
I have 2-3 update panel in my page and i don't want to load chart every time when my page loads or button clicks etc. I put that in update panel with triggers means only some clicks should loads chart. but that chart gets loaded everytime. how to stop that from loading
View 2 RepliesI have gridview in my page that use below code for pagination
<asp:GridView ID="GridView2" runat="server"
AutoGenerateColumns = "false" PagerStyle-CssClass = "GridPager" PagerSettings-Mode="NumericFirstLast" PagerSettings-PageButtonCount = "5"
AllowPaging ="true" OnPageIndexChanging = "OnPaging1" OnRowDataBound = "OnRowDataBound" PageSize = "5" ">
PagerSettings Mode="NumericFirstLast" PageButtonCount="5" FirstPageText="first"
LastPageText="last"></PagerSettings>
[CODE]....
I have used objectdatasource with Gridview.
I have total 3000 records in DB.
In gridview settings:
AllowPaging="True",
PageSize="1000"
but on click on page number in the footer the page is changing but data is not refreshing.
I have an ASP.NET page using the AJAX library. There is a dropdownlist inside an UpdatePanel, which on index changing is supposed to update a different UpdatePanel to modify a grid control.But after the page first comes up, and you adjust the ddl, the entire page postbacks, followed by a (correct) partial postback. After this one time, every other usage of the ddl performs correctly, trigger partial postbacks.
Both the panel and the ddl are being added from code. The UP is Conditional updates and ChildrenAsTriggers = true. The dropdownlist is AutoPostBack true and has an event set up on SelectedIndexChanged.So what is going on? I've tried adjusting every setting I can think of and still the page completely refreshes once, then works fine after that.
I have a page with two columns. Initially, the left column will contain a list of links that are article titles. Clicking on one of the links will display the text of the article in the right column, keeping the list of titles in the left column. Clicking on another title will clear the text of the first article and display the second. Is there a way to accomplish this without having to repaint the whole page? I would rather not have the whole page resent each time a title is clicked, but rather have the page stay as is and only the contents of the right column get cleared and redisplayed. I assume there's a way to do this with JavaScript.
View 5 RepliesThe gridview is not displaying when the page load even though I have bind the gridview with the datasource.... below is the code..
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DSF_View_ChangeRequest.aspx.cs" Inherits="DSF_View_ChangeRequest" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[code]...
So I have a repeater which binds page numbers. That's all fine. I need to know how to make the paging so that they are in "chunks" of a max of 10 page numbers being displayed at a time.Then if they select a page number, it will show the previous x pages and the next y pages (within the 10 chunk range). similar to google paging I guess. Not using pagedDataSource/gridview/gridlist! This is just purely getting the page numbers.
View 1 RepliesI'm having a bit of trouble with Paging within a GridView grid I have set up. I have added the paging but whenever I click on the next page or the last page buttons, the page refreshes and displays blank (i.e. no gridview but my regular search parameters are displayed.
I was trying to search for a solution throughout the web and came across someone that looked to have the same issue. He moved all of his queries into the Page Load method, and the paging seemed to work. I cannot do this because I have 2 different buttons: Search and My Order, both of which perform different queries based on if a date has been selected or what the search is on (Order Number, License Number, Description, Status, etc).
My paging method looks as follows:
[Code]....
From what I can tell this is an issue with no longer having the data set when making the paging call. Is there anythign that I can do?
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]....
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 RepliesI am trying to set a focus on a dropdown within GridView(gridViewDropDown class) when page loads:
if ($('select.gridViewDropDown').length)
{
alert("Found my dropdown");
//$('select.gridViewDropDown:first').focus();
setTimeout(function() { $('select.gridViewDropDown').focus(); }, 10);
}
I can see the alert which means that dropdown is found but it never gets a focus. What do I need to change here? I am using IE 6/7.
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
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).
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 >
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]....
