Home
Get Started
Learn
Downloads
AJAX
MVC
Community
Wiki
Forums
Sign in
|
Join
Home
›
ASP.NET Forums
›
Search
Search
You searched for the word(s): userid:332682
More Search Options
RSS Available
Matching Posts
Re: Gridview Custom Paging takes long when skipping to last page
Hi, I am using a stored procedure and I am making a C#.NET call using ExecuteReader. When I make a big page jump, the call of ExecuteReader is the one that blocks for a long time, so it is actually the stored procedure which takes long. The gridview is bound to an objectdatasource. However, it returns quickly when navigating page by page, and if, say, you are on page 999 and press the "Next" button it will also be very quick (
Posted to
Data Presentation Controls
(Forum)
by
timothym
on 12/8/2007
Re: Gridview Custom Paging takes long when skipping to last page
Hi PureWeen, From what I can understand, when you make a big "jump" in page number, for example, from page 1 to 1000, or something like that, the query takes longer to execute. My query uses ROW_NUMBER to paginate through over 3.5 million records. It orders them according to a certain column (included in a nonclustered index), descending, and selects the top 20 for each page. So, as far as I can tell, if you loop page by page (with the "Next" button), it is very quick (
Posted to
Data Presentation Controls
(Forum)
by
timothym
on 12/8/2007
Re: Gridview Custom Paging takes long when skipping to last page
Hi PureWeen, Thanks for your reply. I am using SQL Server 2005 Express Edition, but I am unsure as to where I can obtain the profiler for this SQL Server edition. Is it available, and, if yes, where can I download it? Thanks again, Timothy
Posted to
Data Presentation Controls
(Forum)
by
timothym
on 12/7/2007
Gridview Custom Paging takes long when skipping to last page
Hi, I have implemented a gridview (gvGames) which is bound to an object data source, and it uses custom paging. The stored procedure returns the exact page of data that is needed together with the total count. In the pager template, I have implemented the "Previous" (btnPrevious) and "Next" (btnNext) buttons, and also, a textbox (txtGotoPage) and a Go button where the user can skip to the page required. The problem I am encountering is that if the user searches with wide criteria
Posted to
Data Presentation Controls
(Forum)
by
timothym
on 12/7/2007
Filed under: object data source, custom paging, GridView
Re: Enabling Button but not firing server side Click event
Hello Hong, There seems to be a problem with the approach you suggested. onkeydown="if ((event.which && event.which == 13) || (event.keyCode && event.keyCode == 13)) {document.myForm.myHtmlInputButton.click();return false;} else return true;" The .click() function does not work on Firefox, even though it is OK on IE. Do you know of any alternative as I have been looking around unsuccessfully. Thanks! Timothy
Posted to
Web Forms
(Forum)
by
timothym
on 11/5/2007
Re: Enabling Button but not firing server side Click event
[quote user="Hong-Gang Chen - MSFT"] [quote user="timothym"] The problem is that to make my site compatible with both IE and Firefox, I used the: UseSubmitBehaviour="false" attribute in the <asp:Button> in question. This is due to the fact that the defaultbutton (btnSearch) in the panel does not "click" when pressing ENTER in Firefox and the suggested remedy was to do the UseSubmitBehaviour together with a line of javascript. This made it work in both
Posted to
Web Forms
(Forum)
by
timothym
on 10/31/2007
Re: Enabling Button but not firing server side Click event
The problem is that to make my site compatible with both IE and Firefox, I used the: UseSubmitBehaviour="false" attribute in the <asp:Button> in question. This is due to the fact that the defaultbutton (btnSearch) in the panel does not "click" when pressing ENTER in Firefox and the suggested remedy was to do the UseSubmitBehaviour together with a line of javascript. This made it work in both browsers. However, apparently, it causes the issue with the server side event not
Posted to
Web Forms
(Forum)
by
timothym
on 10/29/2007
Enabling Button but not firing server side Click event
Hi, I have the following scenario: I have a button appearing on a panel in a form, which I want to be disabled initially. So in the <asp:Button> tag I am putting: Enabled="false". Now, after the user types some characters in a textbox, I want to enable it again, so I have included a javascript function "checkEnableDisableSearchButton"...I added the onKeyUp attribute to the textbox to call the javascript function and, if 3 characters are typed in the textbox, it enables the
Posted to
Web Forms
(Forum)
by
timothym
on 10/28/2007
Filed under: ASP .net 2.0 Button javascript onKeyUp
Re: Page not served. Need to use IIS instead of Cassini
Hi GavDraper, Thanks for your reply. Seems to do the trick neatly! Timothy
Posted to
Visual Studio 2005
(Forum)
by
timothym
on 10/21/2007
Page not served. Need to use IIS instead of Cassini
Hi, I need to display an .asp (Classic ASP) site in an <iframe>. However, Visual Studio 2005 is complaining saying that that type of extension (.asp) is not served...I looked around and saw that the solution would be to use IIS instead of Cassini during the debugging session. However, I am not quite sure how to do this...I am using Windows Vista and have just installed IIS. I would greatly appreciate your help! Thanks, Timothy
Posted to
Visual Studio 2005
(Forum)
by
timothym
on 10/19/2007
Filed under: Visual Studio 2005, Classic ASP, extension, iis, Cassini
Page 1 of 10 (94 items) 1
2
3
4
5
Next >
...
Last »
Silverlight:
ASP.NET 4, ASP.NET MVC, and Silverlight 4 Videos of my Talks in Europe
Channel 10:
Faster Solid State Drives for Windows 7 Arrive
ASP.NET:
Death to confirmation dialogs with jquery.undoable
Channel 9:
E2E: Brian Beckman and Erik Meijer - Co/Contravariance in Physics and Programming, 1 of 2
TechNet Edge:
Windows Server 2008 R2 Quick Look #3 - PowerShell V2
ASP.NET:
2009 Blogged - Greatest Hits
WindowsClient:
2009 Blogged - Greatest Hits
Channel 9:
Nikolaj Bjørner and Leonardo de Moura: The Z3 Constraint Solver
Channel 9:
MEF & Silverlight 4 Beta - Part 2, Imports & Exports
Channel 9:
MEF & Silverlight 4 Beta - Part 1, Introduction
WindowsClient:
The (Near) Final Word on Multi-Monitor Taskbars for Windows 7 - Ultramon vs. DisplayFusion
WindowsClient:
Looking back at 2009, and forward to 2010
Silverlight:
Polling Video – A Viable sub-second alternative?
TechNet Edge:
Windows Server 2008 R2 Quick Look #2 - Active Directory Recycle Bin
Channel 10:
I'm a Windows 7 PC Themes
Channel 10:
24 Years of Windows Box Art
WindowsClient:
Silverlight tutorial: HOW TO build CommandLink Control in Silverlight with Expression Blend 3 and Behaviors
ASP.NET:
Converting an RGB Color To Hex With JavaScript
Silverlight:
Silverlight HVP Design – Configuration & Scenarios
Channel 9:
Channel 9 Live at PDC09: Day 3 Welcome
Microsoft Communities
ASP.NET
Channel 8
Channel 9
Channel 10
IIS.NET
Silverlight
TechNet Edge
WindowsClient
Mix Online