Oh sorry guys I forgot to setAdapter . After writing setListAdapter(myAdapter); it works fine
On Dec 10, 9:47 am, "pramod.deore" <[email protected]> wrote: > Anyone know what is wrong here? > > On Dec 10, 8:58 am, "pramod.deore" <[email protected]> wrote: > > > Hi I had write a code that read data from database and display it > > using SimpleCursorAdapter. Here is my .java file > > public class SimpleCursorDemo extends ListActivity { > > > String SAMPLE_DBNAME = "NewHomeAutoDataBase"; > > private SimpleCursorAdapter myAdapter; > > SQLiteDatabase sampleDB = null; > > private final String LOADTYPE_TABLE_NAME = "LoadTable"; > > > @Override > > public void onCreate(Bundle savedInstanceState) > > { > > super.onCreate(savedInstanceState); > > sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, > > MODE_PRIVATE, null); > > createTableForLoadType(); > > > try > > { > > Cursor c = sampleDB.rawQuery("SELECT _id,LoadType,SwitchName > > FROM " +LOADTYPE_TABLE_NAME , null); > > startManagingCursor(c); > > > String[] columns = new String[] {"LoadType", "SwitchName"}; > > int[] names = new int[] {R.id.room, R.id.switch1}; > > > myAdapter = new SimpleCursorAdapter(this, R.layout.main, c, > > columns,names); > > > } > > catch (Exception e) > > { > > e.printStackTrace(); > > } > > > } > > > public void createTableForLoadType() > > { > > try > > { > > sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " + > > LOADTYPE_TABLE_NAME + > > " (_id INTEGER PRIMARY KEY > > autoincrement ,SwitchName varchar,LoadType int,FedType int,Speed > > int);"); > > > sampleDB.execSQL("INSERT INTO " + > > LOADTYPE_TABLE_NAME + > > " Values (null,'Tube > > Light','0',null,null);"); > > > sampleDB.execSQL("INSERT INTO " + > > LOADTYPE_TABLE_NAME + > > " Values (null,'kElectric > > Bell','0',null,null);"); > > > sampleDB.execSQL("INSERT INTO " + > > LOADTYPE_TABLE_NAME + > > " Values (null,'Bulb','1',null,null);"); > > > System.out.println ("After inserting data to > > LoadType"); > > > } > > catch (Exception e) > > { > > e.printStackTrace(); > > } > > > } > > > } > > > and my main.xml is like > > > <?xml version="1.0" encoding="utf-8"?> > > <LinearLayout xmlns:android="http://schemas.android.com/apk/res/ > > android" > > android:orientation="horizontal" > > android:layout_width="fill_parent" > > android:layout_height="fill_parent"> > > <ImageView > > android:src="@drawable/icon" > > android:layout_width="wrap_content" > > android:layout_height="wrap_content" > > /> > > <LinearLayout > > android:orientation="vertical" > > android:layout_width="fill_parent" > > android:layout_height="fill_parent"> > > <LinearLayout > > android:orientation="horizontal" > > android:layout_width="wrap_content" > > android:layout_height="wrap_content"> > > <TextView > > android:layout_width="wrap_content" > > android:layout_height="wrap_content" > > android:text="Room Name: " > > /> > > <TextView android:id="@+id/room" > > android:layout_width="wrap_content" > > android:layout_height="wrap_content" > > /> > > </LinearLayout> > > <LinearLayout > > android:orientation="horizontal" > > android:layout_width="wrap_content" > > android:layout_height="wrap_content"> > > <TextView > > android:layout_width="wrap_content" > > android:layout_height="wrap_content" > > android:text="Switch Name: " > > /> > > <TextView android:id="@+id/switch1" > > android:layout_width="wrap_content" > > android:layout_height="wrap_content" > > /> > > </LinearLayout> > > </LinearLayout> > > </LinearLayout> > > > But when I run application then it doesn't show any output. It also > > not throw any exception. I think my problem is in xml file. Anyone > > know what's wrong in this? > > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
