http://developer.android.com/reference/android/widget/SimpleCursorAdapter.html
String On Nov 26, 6:05 am, "pramod.deore" <[email protected]> wrote: > Hi, I have a table which contain 4columns. I can read these columns > from database. Now I want to show these columns to listview. How to > this? I want that list consist of 4 columns as they are present into > table. > > Here is my code: > > public class ToDo extends Activity > { > private final String SAMPLE_DBNAME = "HomeAutoDataBase"; > SQLiteDatabase sampleDB = null; > int rid,sid; > String roomName,switchName; > /** Called when the activity is first created. */ > @Override > public void onCreate(Bundle savedInstanceState) > { > super.onCreate(savedInstanceState); > readDataFromDatabase(); > > } > public void readDataFromDatabase() > { > try > { > sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, > MODE_PRIVATE, null); > Cursor c = sampleDB.rawQuery ("SELECT * FROM SwitchTable > ORDER BY RoomID",null); > > int count = c.getCount(); > System.out.println ("Total number of records are"+count); > if (c != null ) > { > if (c.moveToFirst()) > { > do > { > rid = > c.getInt(c.getColumnIndex("RoomID")); > sid = > c.getInt(c.getColumnIndex("SwitchID")); > > roomName = > c.getString(c.getColumnIndex("RoomName")); > switchName = > c.getString(c.getColumnIndex("SwitchName")); > > System.out.println > (rid+":"+roomName+":"+sid > +":"+switchName); > > } > while (c.moveToNext()); > c.close(); > } > } > > } > catch (SQLiteException se ) > { > Log.e(getClass().getSimpleName(), "Could not create or Open > the database"); > } > finally > { > sampleDB.close(); > } > } > > > > > > > > } -- 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
