Custom paging

[Saravana]

Another option for custom paging is

1. Get all the primary key column values in the page load event.
2. Store these values in the session cache as a separate data set.
3. The above data set will have one column that has the values of the
primary key in the interval of the page size.
4. When a new page is requested, Get the starting primary key value for that
page from the session and then hit the database to get the records.

I hope this helps you


--
Saravana
Microsoft India Community Star,
MCAD,SE,SD,DBA.


"sampriti" <sampritivaram@hotmail.com> wrote in message
news:090101c34633$48d486f0$a001280a@phx.gbl...

> Hi,
> I am implementing custom pagination on my datagrid to
> retrieve only desired no of records. For this I am
> creating temporary table with identity column and
> inserting rows from the query into temporary table within
> the storedprocedure. I retrieve the rows from temporary
> table by passing startingID and Ending ID to the stored
> procedure. I set rowcount to EndingID and query the
> temporary table by specifying where condition (rowNum
> (which is identity field)> StartingID)
>
> The results will vary for each user as it is a search
> application. But the problem is the ASP.NET account pools
> the different users of the application into a small set of
> connections to SQL Server. 500 users only translates to
> roughly 5 connections in SQL Server. There is no way to
> differentiate between user a and user b on the SQL Server
> side. All connections to SQL Server use a single account
> (what is defined in web.config). So, using a temporary
> table may be a problem.
>
> Is there a way to solve this problem?

[Kilic Beg]

Hi,

I implement datagrid for my customer database regular paging.
I want to change the paging so that it display the letters A...Z which are
the first letter of the
customer names...
When the users clicks on the letter 'K' I want to display all the customers
where the first letter is 'K'

The store proc always returns all the customers...

does anyone has a sample code where I can get started.
I appreciate any help.

- Kilic

[Raterus]

The simpleist solution I can think of, is to have 26 link buttons at the top of the datagrid (not exactly part of the datagrid), each has a commandargument set to the letter it designates. Let all of them work off the same "command" handler. In this handler, get the commandargument, and rebind the data accordingly to the datagrid. This really isn't paging, but you could at this point enable paging on your datagrid, so they could page through the results for each letter. Fun Fun


"Kilic Beg" <kbeg@salary.com> wrote in message news:ucL$KVZSEHA.3016@tk2msftngp13.phx.gbl...

> Hi,
>
> I implement datagrid for my customer database regular paging.
> I want to change the paging so that it display the letters A...Z which are
> the first letter of the
> customer names...
> When the users clicks on the letter 'K' I want to display all the customers
> where the first letter is 'K'
>
> The store proc always returns all the customers...
>
> does anyone has a sample code where I can get started.
> I appreciate any help.
>
> - Kilic
>
>

[Saravana [MVP]]

Here is the example for your requirement.
[url]http://www.codeproject.com/aspnet/LetterBasedPaging.asp[/url]

--
Saravana
Microsoft MVP - ASP.NET
[url]www.extremeexperts.com[/url]



"Kilic Beg" <kbeg@salary.com> wrote in message
news:ucL$KVZSEHA.3016@tk2msftngp13.phx.gbl...

> Hi,
>
> I implement datagrid for my customer database regular paging.
> I want to change the paging so that it display the letters A...Z which are
> the first letter of the
> customer names...
> When the users clicks on the letter 'K' I want to display all the

customers

> where the first letter is 'K'
>
> The store proc always returns all the customers...
>
> does anyone has a sample code where I can get started.
> I appreciate any help.
>
> - Kilic
>
>

[Kilic Beg]

thanks for your help guys...
"Saravana [MVP]" <saravank@sct.co.in.nospam> wrote in message
news:uYR8hEgSEHA.1372@TK2MSFTNGP10.phx.gbl...

> Here is the example for your requirement.
> [url]http://www.codeproject.com/aspnet/LetterBasedPaging.asp[/url]
>
> --
> Saravana
> Microsoft MVP - ASP.NET
> [url]www.extremeexperts.com[/url]
>
>
>
> "Kilic Beg" <kbeg@salary.com> wrote in message
> news:ucL$KVZSEHA.3016@tk2msftngp13.phx.gbl...

> > Hi,
> >
> > I implement datagrid for my customer database regular paging.
> > I want to change the paging so that it display the letters A...Z which

are

> > the first letter of the
> > customer names...
> > When the users clicks on the letter 'K' I want to display all the

> customers

> > where the first letter is 'K'
> >
> > The store proc always returns all the customers...
> >
> > does anyone has a sample code where I can get started.
> > I appreciate any help.
> >
> > - Kilic
> >
> >

>
>

[aspnetpal]

Hi every1, I'm having problem with custom paging.
I've used the sample from dotnetjunkies Thanks to Doug for putting
together such a wonderful example.

I've made some changes to fit the needs.

Problem on Hand:
When user clicks on the Navigation links (First, Next, Prev, or Last)
after page load it still loads the same first page.
However after the page load it changes the number of page.
For example, Page # of Total_Pages will change to
Page 2 of Total_Pages.

This shows that Item collections works (implemented using stored
procedure ...).

Here's my guess, for some reason I'm thinking the following line of
code is not working.

Case "Next"
_currentPageNumber = Int32.Parse(CurrentPage.Text) + 1

or maybe I'm missing something ...

Any suggestions or help would be highly apprecitated.
If you like to see any part of the code let me know and I can post it.

Thanks in advance.