Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

show all is not paginating datapager

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
TonyReba
Asked:
TonyReba
  • 3
  • 2
1 Solution
 
kaylanreilorCommented:
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
 
TonyRebaAuthor Commented:
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
 
kaylanreilorCommented:
"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
 
TonyRebaAuthor Commented:
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
 
TonyRebaAuthor Commented:
I ended up adding a new listview withs its corresponding satasource and setting visible to false..
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now