Paging in ScrollView

[Slacker]

Hello Folks, i'm a newbie (in Android app developing i mean...i have a C,C# background over 10 years) !
I'm beginning to develop apps from....today basic4app is an excellent resource, thank you to all community.

Let's go to hard!
I'm looking for ScrollView control because i'm developing an app to allow an user to connect to my web online community (remote sql server) and see the other users. The target is to allow this app, to interacting in real time with the users on the web community by connecting through. Questions are 2 (for now):

1) I suppose the app should be based to a model which make remote sql queries to get result to shoot on the display. What should be the better way to make a remote query on my sql server and get a list of users or any result ?

2) Is it possible to get a paging model in scrollview being it could happen to get a lot of users to display (in ASP.NET i used the Pager control linked to ListView) ?

Thank you in advance to all!

 

[Erel]

1) See this tutorial: Connect Android to MS SQL Server Tutorial

2) How many is a lot of users?

 

[Slacker]

Hello Eriel,
mine is a community like a social network. I've about 33.000 users; of course i'm not going to show all them in one shoot; but if a user search for its region, it could find about 2.000, 3.000 users. I cannot show 3.000 users in a cascade style; like every application on the web, subdivide them in pages, like a listview in asp.net controls, should be the ideal scenario.

But is it possible (without making an extreme hard coding...) ????????? :sign0104:

 

[Slacker]

Is so hard to get it ? :sign0163:

 

[Informatix]

Is so hard to get it ? :sign0163:

Creating multiple pages for a list does not stick to the philosophy of Android (where long lists are preferred, with a search function or an index) but that should be easy to do with a TabHost or a few panels. So I don't see what is exactly the problem here.

 

[Slacker]

The problem is:

Search users for region: resulting users = 1500
List users: 20 for each page and show the pages links (first-1,2,3,4,5...last) to click for list the next ones.

I cannot show 1500 users in one view to scroll....it should be horrible...

 

[Informatix]

The problem is:

Search users for region: resulting users = 1500
List users: 20 for each page and show the pages links (first-1,2,3,4,5...last) to click for list the next ones.

1) Does the user really need to display the full list (paged or not paged)?
2) If no, what's the clever way to find the needed info (an index, a search field, a tree, ...)?
If yes, can the whole list be retrieved quickly from the server or is the pagination mandatory to avoid an excessive amount of downloaded data?
Is there another reason (not subjective) for a paged list?

I cannot show 1500 users in one view to scroll....it should be horrible...

I can't see why a long list that you scroll is horrible (it's what you have in most Android apps), but ok, you don't want it.

 

[Slacker]

The paging is more comfortable because as you told, often the user needs to navigate through a large quantity of users (he wants to see all ones from his Region...and they could about 1000,2000). Scrolling between 2000 users in one shoot, should be pretty hard especially if the user holds in his mind another user about 1200, 1300 previous rows in the list and after scolling he wants scroll back to it (with paging he holds the page reference that's more comfortable and fast to get..).

Yes, of course, i can apply a search filter....but often my users, feel the need to list the users living in region they belong to and such users, may be a thousands....

Further, retrieving all users in one trip from the server should be pretty expensive....

So, what do u suggest ?