Solved

show all is not paginating  datapager

Posted on 2010-08-24
5
436 Views
Last Modified: 2012-05-10
I have a listview control asp.net 3.5 in m web app. I want to have a way to show all the data from my database at the buttonshowall click event, it works fine but since is part of the listview it doesnt sort nor, paginate ,,,, much help is appreciated.
0
Comment
Question by:TonyReba
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:kaylanreilor
ID: 33518325
You don't give any info on how are you currently trying to sort...
Waiting for some details, here is a generic example from the MS doc : http://support.microsoft.com/kb/319401.
0
 
LVL 9

Author Comment

by:TonyReba
ID: 33521130
here is my show all code behind
Protected Sub showallButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles showallButton.Click
        ' Show All Results 
        Dim sql As String
        sql = "SELECT [First Name], [Last Name], [Prof Designation],[Specialty], [Specialty2],[Address], [Address2], [City], [State], [Zip], [Phone], [Fax] FROM [tbl_Providers] ORDER BY [Last Name], [Specialty] "
        AccessDataSource2.SelectCommand = sql
        ListView1.DataBind()
       
    End Sub

Open in new window

0
 
LVL 13

Expert Comment

by:kaylanreilor
ID: 33522084
"it works fine but since is part of the listview it doesnt sort "
This is a little bit confusing: what is part of the listview? what does work actually?
Also, do you see the page refreshing after calling ListView1.DataBind() ?

0
 
LVL 9

Author Comment

by:TonyReba
ID: 33522355
Hi, yes I see the first set of names displayed once I clicked on show all but when I clicked next on the pager control I dont see the remainding names..

0
 
LVL 9

Accepted Solution

by:
TonyReba earned 0 total points
ID: 33527920
I ended up adding a new listview withs its corresponding satasource and setting visible to false..
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question