Can Someone Please explain the following in Detail : (Basics of Paging)
1. Working Sets
2. Standby List
3. Modified List
4. Free List
5. Zero List
and how they relate to one another. Help much appreciated. Thanks.
View Complete Post
MSDN Magazine February 2004
There are a number of ways to handle paging in Web applications. This month I'll examine several paging techniques and weigh their pros and cons. John Papa discusses how to manage paging and caching issues through the lower tiers of an n-tiered architecture, including how to make SQL Server manage the paging on your app's behalf.
MSDN Magazine May 2003
I have a problem displaying data in a Grid View control when I set a row to visible = false when a certain condition is true.
For example, if a DataRowData value has a condition set to true (custom in table) I set the visible property to false, so the data row will not be visible at run time.
The problem is that I'm using paging (10 rows per page) and if 8 of those rows fall into the true condition that won't show the row, that grid view page will only show two rows of data in page 1. The worst scenario is that if I go to page 2 of the grid view and all the rows (10) fall into the true condition, that grid view page will not show any data at all.
How can I show 10 rows of data at all times in a gridview? In other words, I would like to just show the visible rows at all times.
Any help will be greatly appreciated.
Has anyone found a solution that will allow me to have page numbers for paging in a data view web part. For instance, if I have 40 items/rows and I set the paging to display 10 items, I'd like the paging to show 1 2 3 4 rather than showing 1-10 and having
to click next over and over to get to a specific item.
I found this article, but it is for 2003 and doesn't seem to apply to 2007 or if it does I am not able to really figure out how.
Thanks in advance.
protected override void CreateChildControls()
// Create and add the controls that make up the
// user interface of the web part.
scopesDropDown = new DropDownList();
txtQueryText = new TextBox();
cmdSearch = new Button();
cmdSearch.Text = "Start Search";
cmdSearch.Click += new EventHandler(cmdSearch_Click);
lblQueryResult = new Label();
void cmdSearch_Click(object sender, EventArgs e)
The issue is two fold in my ASP.NET Web Application. I need to use a custom Distinct() via LINQ to SQL, and then assign thevar as a DataSource to a GridView. If I use the custom Distinct that implements IEqualityComparer, I get "Unsupported overload used for query operator 'Distinct'" exception. but if i somehow get past this, i get "The data source does not support server-side data paging" exception on GridView.DataBind(). here is the code:
(from emp in wsq.LIT_Active_Employees
where (String.IsNullOrEmpty(ssFirstName.Text) ? (emp.FIRST_NAME == null || emp.FIRST_NAME.StartsWith(String.Empty)) : emp.FIRST_NAME.Contains(ssFirstName.Text)) &&
(String.IsNullOrEmpty(ssLastName.Text) ? (emp.LAST_NAME == null || emp.LAST_NAME.StartsWith(String.Empty)) : emp.LAST_NAME.Contains(ssLastName.Text)) &&a