Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have a similar function in my app. You will need to create a XML file to define the layout for the list and call them in your java code.</p> <p>Here is the example XML:</p> <p>LIST:</p> <pre><code>&lt;LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_weight="1" android:orientation="vertical" &gt; &lt;ListView android:id="@android:id/list" android:layout_width="fill_parent" android:layout_height="fill_parent" android:layout_weight="1" &gt; &lt;/ListView&gt; &lt;TextView android:id="@+id/android:empty" android:layout_width="fill_parent" android:layout_height="fill_parent" android:text="@string/no_projects" android:padding="10dp" android:textSize="16sp" android:textStyle="bold" &gt; &lt;/TextView&gt; &lt;/LinearLayout&gt; </code></pre> <p>This is the custom layout XML. I call it list_rows:</p> <pre><code>&lt;LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_weight="1" android:orientation="vertical" &gt; &lt;TextView android:id="@+id/text1" android:layout_width="fill_parent" android:layout_height="wrap_content"&gt; &lt;/TextView&gt; &lt;TextView android:id="@+id/text2" android:layout_width="fill_parent" android:layout_height="wrap_content"&gt; &lt;/TextView&gt; &lt;TextView android:id="@+id/text3" android:layout_width="fill_parent" android:layout_height="wrap_content"&gt; &lt;/TextView&gt; &lt;/LinearLayout&gt; </code></pre> <p>And this is the JAVA code:</p> <pre><code>String[] fields = new String[] { db.TABLE_PRJ_NAME, db.TABLE_PRJ_TYPE, db.TABLE_PRJ_DESC }; int[] views = new int[] { /*android.R.id.text1*/ R.id.text1, R.id.text2, R.id.text3 }; c = db.getAllProjects(); startManagingCursor(c); // Set the ListView SimpleCursorAdapter prjName = new SimpleCursorAdapter( this, R.layout.project_list_rows, //android.R.layout.simple_list_item_1, c, fields, views); setListAdapter(prjName); </code></pre> <p>The onListItemClickListener</p> <pre><code>// This section of code is for handling the Click Event of the Projects List @Override protected void onListItemClick(ListView l, View v, int position, long id) { super.onListItemClick(l, v, position, id); Cursor o = (Cursor) this.getListAdapter().getItem(position); String projectName = o.getString(1); Intent showProjectDetails = new Intent(this, ProjectDetails.class); Bundle bundle = new Bundle(); bundle.putString("sendProjectName", projectName); showProjectDetails.putExtras(bundle); startActivity(showProjectDetails); } </code></pre> <p>What the new part of the code is doing is just sending the selected item to another activity through an intent. Then in the new activity, I am querying the DB using the selected item name from the bundle and displaying the result.</p> <p>Do ask if you need further explanation.</p>
    singulars
    1. This table or related slice is empty.
    1. PODisplaying Cursor Results from DB in ListView after OnItemClick
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSiddharth Lele
    1. USSiddharth Lele
    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
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSiddharth, That is what I already have, if you looked at my code. I am having trouble with having this code run without errors while doing what I need done. Can you post the entire source instead of an excerpt? Do you even use OnItemClick? Thanks...
      singulars
      1. PO
      1. USDevin
    2. COAdding the additional code. Check the original post.
      singulars
      1. PO
      1. USSiddharth Lele
    3. COI'm really sorry but I'm having trouble here. I understand what is involved in preparing the Cursor and creating a SimpleCursorAdapter. However, I don't want a new Activity. I want it so if someone clicks on an item in the list, it will query the DB and return a list of all words in the category that was clicked on. I have tried the code you posted, and I end up having to force quit when opening that Activity (I can't even get to the category list to test). The code I have posted above works if you remove the SimpleCursorAdapter declaration and the setListAdapter call on the next line.
      singulars
      1. PO
      1. USDevin
 

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