How to implement a Custom ArrayAdapter with data from SQLite

Question

I'm developing an app with a list that should show the name, phone and e-mail addresses of users previously registered on a sqlite database. In each row will also have two buttons.

Something like this:

ListFragment:
-------------------- 
[Name 1] 
[Phone 1] 
[E-mail 1] 
[Button 1][Button 2] 
-------------------- 
[Name 2] 
[Phone 2] 
[E-mail 2] 
[Button 1][Button 2] 
-------------------- 
... (and so on) ...

where the button 1 will make a call and the button 2 will send an email to person. detail, these buttons are clickables ImageView.

I managed to create the XML correctly.

And I know I will need to implement a Custom ArrayAdapter with data from my SQLite database.

I really need to know what is the BEST WAY to implement a Custom ArrayAdapter with data from SQLite ??? I saw so many different ways that I'm totally confused.

please can someone help me with this? if there is a tutorial that explains in detail how to do this, I thank you very much.

"And I know I will need to implement a Custom ArrayAdapter with data from my SQLite database." no, you don't need any ArrayAdapter, what you need is a SimpleCursorAdapter — pskink
– pskink, Commented Sep 8, 2014 at 23:42
I've tried with SimpleCursorAdapter. but does not work because the SimpleCursorAdapter does not allow to implement actions to the buttons. — Melk Lima
– Melk Lima, Commented Sep 8, 2014 at 23:54
This is the tutorial I used when getting up to speed on Android Lists and SQLite. I agree with @pskink that what you need is probably a SimpleCursorAdapter, rather than an ArrayAdapter. — emerssso
– emerssso, Commented Sep 9, 2014 at 0:04
I tried now with SimpleCursorAdapter. but it did not work. displays users' information, but I can not make the buttons work. remembering that my main goal is that when clicking on the first button call the phone number of row in the list and when clicking on the second button send an e-mail to that user. — Melk Lima
– Melk Lima, Commented Sep 9, 2014 at 1:10
ie multiple clickable parts with different actions to peform in listfragment — Melk Lima
– Melk Lima, Commented Sep 9, 2014 at 1:16

Community · Accepted Answer · 2017-05-23 11:58:35Z

0

It looks like this question has the answers you're looking for. You might also try the links in the accepted answer in this question.

Basically, it looks like what you want to do is:

Create a custom descendant of SimpleCursorAdapter
Override getView
1. Handle inflation of your row using your custom view
2. Set OnClickListeners for each button

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Sep 9, 2014 at 14:24

emerssso

2,39620 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement a Custom ArrayAdapter with data from SQLite

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related