Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here is what I would do to put contacts in a listView</p> <p>In your activity:</p> <pre><code>private ListView mContactsListView; private ListContactItemAdapter mContactsListAdapter; this.mContactsListAdapter = new ListContactItemAdapter(this, R.layout.contact_row); // after doing setContentView, assuming you have defined a listview in your layout file this.mContactsListView= (ListView) this.findViewById(R.id.contactsListView); // You may want to create a custom adapter, which I wrote below for showing you example this.mContactsListView.setAdapter(this.mContactsListAdapter); for (/* each contact */) { Contact contact = new Contact(); contact.name = contactName; contact.number = contactNumber; this.mContactsListAdapter.add(contact); } // In order to refresh your list and make data appear this.mContactsListAdapter.notifyDataSetChanged(); </code></pre> <p>Of course in my example you need a model object containing contact data:</p> <pre><code>public class Contact { public String name; public String number; } </code></pre> <p>And this could be your custom adapter using the Contact class above:</p> <pre><code>public class ListContactItemAdapter extends ArrayAdapter&lt;Contact&gt; { private int mLineLayout; private LayoutInflater mInflater; public ListContactItemAdapter(Context pContext, int pLineLayout) { super(pContext, pLineLayout); this.mLineLayout = pLineLayout; this.mInflater = (LayoutInflater) pContext.getSystemService(Context.LAYOUT_INFLATER_SERVICE); } static class ViewHolder { TextView contactName; TextView contactNumber; } @Override public View getView(int pPosition, View pView, ViewGroup pParent) { ViewHolder holder; if (pView == null) { pView = this.mInflater.inflate(this.mLineLayout, null); holder = new ViewHolder(); holder.contactName = (TextView) pView.findViewById(R.id.contactName); holder.contactNumber = (TextView) pView.findViewById(R.id.contactNumber); pView.setTag(holder); } else { holder = (ViewHolder) pView.getTag(); } Contact contact = getItem(pPosition); if (contact != null) { holder.contactName.setText(contact.name); holder.contactNumber.setText(contact.number); } return pView; } </code></pre> <p>}</p> <p>For that example your need a layout to define rows, of your listview. This could be a contact_row.xml example:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" &gt; &lt;TextView android:id="@+id/contactName" android:layout_width="wrap_content" android:layout_height="wrap_content" android:paddingLeft="6dp" android:text="Contact name" android:textAppearance="?android:attr/textAppearanceMedium" /&gt; &lt;TextView android:id="@+id/contactNumber" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/contactName" android:paddingLeft="6dp" android:text="number" android:textAppearance="?android:attr/textAppearanceSmall" /&gt; &lt;/RelativeLayout&gt; </code></pre> <p>I didn't try but this should work. And anyway, I hope it will make you understand how listviews basically work.</p>
    singulars
    1. This table or related slice is empty.
    1. POAndroid contacts - Retrieved Android contacts, how to put them in a simple ListView?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMichel-F. Portzert
    1. USMichel-F. Portzert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you all very much for your kind assistance, I know have a fully working application after hours of trying and tearing out clumps of hair!! Thank you so very much
      singulars
      1. PO
      1. USuser1593869
    2. COHi There, after a bit of testing I appear to have missed something... When I scroll down the contacts list, the tick box becomes un-ticked and the 'new' top position becomes ticked - if you see what I mean, rather difficult to explain without seeing! Do you have any suggestions?
      singulars
      1. PO
      1. USuser1593869
    3. COItems are recycled while scrolling, so your tick box (checked) is moved around with the recycling process. You should care about the position of your tick boxes, keep track of checked positions, something like that, and manage the tick programmatically inside getView.. or if you want to change your approach by using a CheckedTextView, maybe this answer I made (a long time ago) can help you http://stackoverflow.com/questions/12028167/checkable-listview-cursor-data-independent-checkbox/12029688#12029688
      singulars
      1. PO
      1. USMichel-F. Portzert
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload