Its quite crisp and clear now! Thanks a lot Mark for your enormous help and effective guidelines.
On Oct 23, 9:58 am, Mark Murphy <[email protected]> wrote: > Maxood wrote: > > Also do i have to use the android.database.sqlite.SQLiteQueryBuilder > > for building and running the SELECT query? > > No. It is there as a convenience. I only use it for creating > SQLite-backed content providers. > > > Can you provide me with a sample code for fetching data from table. > > Unfortunately, the ApiDemos only have SQLite as used by a content provider. > > If you want sample uses of SQLiteOpenHelper or SQLiteDatabase, you can > find 100+ up on Google Code Search: > > http://www.google.com/codesearch > > Add "package:android" to your list of search terms, and you'll restrict > your search to only Android-related code. > > There is also an example of non-ContentProvider SQLite usage in the > source code to _Android Programming Tutorials_: > > http://commonsware.com/AndTutorials > > (see Tutorial 12) > > If those examples are insufficient, I recommend you pick up a book that > covers this topic. Here are four: > > _The Busy Coder's Guide to Android Development_, Version 2.1, pages 271-282 > > _Android Programming Tutorials_, Version 1.0, pages 93-108 > > _Professional Android Application Development_, pages 175-188 > > _Android Wireless Application Development_, pages 257-275 > > There probably are other books that cover this as well, but these were > the ones that either I wrote or had their tables of contents up on > Amazon for easy searching. > > If you want to get deeper into SQLite beyond Android, I recommend _The > Definitive Guide to SQLite_. > > -- > Mark Murphy (a Commons > Guy)http://commonsware.com|http://twitter.com/commonsguy > > _Android Programming Tutorials_ Version 1.0 In Print! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
