Here's an article which teaches you how to do it . http://moazzam-khan.com/blog/?cat=26
- Moazzam On Dec 6, 8:19 am, Mark Murphy <[EMAIL PROTECTED]> wrote: > habi wrote: > > hi i created one databse in Sqlite....the databse is stored in raw > > folder.....now how to write the connection coding > > You can't, AFAIK. Databases cannot be used if they are packaged in the APK. > > A pattern that I have used, and will eventually need to blog about, is: > > 1. Create a SQLite database in my project, but not in res/raw/ or any > place where it would get packaged up (e.g., create a db/ folder) > > 2. Use the console sqlite3 utility to dump the contents (schema + data) > of the various tables into SQL scripts in res/raw/ -- you can integrate > this into Ant if you so choose > > 3. In your SQLiteOpenHelper, rather than hard-code the SQL statements to > create and populate your database, open each of your SQL scripts in > res/raw/ and execute the statements contained in them > > -- > Mark Murphy (a Commons Guy)http://commonsware.com > _The Busy Coder's Guide to Android Development_ Version 1.9 Available! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" 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-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
