Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

show all is not paginating  datapager

Posted on 2010-08-24
5
Medium Priority
?
446 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

972 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