StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17318326
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-06-26T11:03:20.610
FavoriteCount
0
LastActivityDate
2013-06-26T11:03:20.610
LastEditDate
LastEditorUserId
0
OwnerUserId
2164411
ParentId
17317731
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code>try something like this .. import java.io.IOException; import java.io.InputStream; import java.util.ArrayList; import java.util.HashMap; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.NodeList; import android.app.ListActivity; import android.content.Intent; import android.graphics.drawable.GradientDrawable; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.TextView; import com.google.ads.AdRequest; import com.google.ads.AdView; public class AndroidXMLParsingActivity extends ListActivity { static final String KEY_ITEM = "item"; // parent node static final String KEY_ID = "id"; static final String KEY_NAME = "name"; static final String KEY_ADDRESS = "address"; static final String KEY_PHONE = "phone"; static final String KEY_ATTRACTION = "attraction"; String xml; int mIndex; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.display); Intent in = getIntent(); mIndex = Integer.parseInt(in.getStringExtra("value")); ArrayList<HashMap<String, String>> menuItems = new ArrayList<HashMap<String, String>>(); XMLParser parser = new XMLParser(); switch (mIndex) { case 0: InputStream stream = getResources() .openRawResource(R.raw.myxml); try { byte[] buffer = new byte[stream.available()]; stream.read(buffer); stream.close(); xml = new String(buffer); } catch (IOException e) { // Error handling } break; } Document doc = parser.getDomElement(xml); // getting DOM element NodeList nl = doc.getElementsByTagName(KEY_ITEM); for (int i = 0; i < nl.getLength(); i++) { HashMap<String, String> map = new HashMap<String, String>(); Element e = (Element) nl.item(i); map.put(KEY_ID, parser.getValue(e, KEY_ID)); map.put(KEY_NAME, parser.getValue(e, KEY_NAME)); map.put(KEY_ADDRESS, parser.getValue(e, KEY_ADDRESS)); map.put(KEY_PHONE, parser.getValue(e, KEY_PHONE)); map.put(KEY_ATTRACTION, parser.getValue(e, KEY_ATTRACTION)); menuItems.add(map); } ListAdapter adapter = new SimpleAdapter(this, menuItems, R.layout.list_item, new String[] { KEY_NAME, KEY_ADDRESS, KEY_PHONE, KEY_ATTRACTION }, new int[] { R.id.name, R.id.desciption, R.id.cost, R.id.sttraction }); setListAdapter(adapter); ListView lv = getListView(); lv.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { String val = "" + mIndex; Intent i = new Intent(getApplicationContext(), MallFinderActivity.class); i.putExtra("value", val); i.putExtra("position", "" + position); String mallName = ((TextView) view.findViewById(R.id.name)) .getText().toString(); i.putExtra("mall", mallName); startActivity(i); } }); } } this is my listitem xml : <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" > <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="vertical" >  <TextView android:id="@+id/name" android:layout_width="fill_parent" android:layout_height="wrap_content" android:paddingBottom="2dip" android:paddingTop="6dip" android:textColor="#dc6800" android:textSize="16sp" android:textStyle="bold" />  <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" > <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:text="Address: " android:textColor="#5d5d5d" android:textStyle="bold" > </TextView> <TextView android:id="@+id/desciption" android:layout_width="fill_parent" android:layout_height="wrap_content" android:paddingBottom="2dip" android:textColor="#000000" > </TextView> </LinearLayout>  <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" >  <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:text="Phone: " android:textColor="#5d5d5d" android:textStyle="bold" > </TextView>  <TextView android:id="@+id/cost" android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:textColor="#000000" android:textStyle="bold" > </TextView> </LinearLayout> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" >  <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:text="Attraction: " android:textColor="#5d5d5d" android:textStyle="bold" > </TextView>  <TextView android:id="@+id/sttraction" android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:textColor="#000000" android:textStyle="bold" > </TextView> </LinearLayout> </LinearLayout> </LinearLayout> this is main.xml <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:ads="http://schemas.android.com/apk/lib/com.google.ads" android:id="@+id/mainlayoutsecond" android:layout_width="fill_parent" android:layout_height="fill_parent" android:orientation="vertical" > <LinearLayout android:layout_width="fill_parent" android:layout_height="fill_parent" android:layout_weight=".1" android:orientation="vertical" > <ListView android:id="@android:id/list" android:layout_width="fill_parent" android:layout_height="fill_parent" android:cacheColorHint="#E3E3E3" android:divider="#b5b5b5" android:dividerHeight="1dp" android:fastScrollEnabled="true" android:focusable="false" /> </LinearLayout> </LinearLayout> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhile parsing xml to listview cannot display anything on listview
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USbaloo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COI have parsed the xml. The problem is "not displaying on listview".
  singulars
  PostPostId
  PO
  UserUserId
  USemreturka

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.