Hi! I think the code help you:
public int addImage(byte[] data, int offset, int numBytes) { if(mSQLLiteDataBase != null) { if(offset >= 0 && numBytes > 0) { byte[] bzMid = null; if(offset == 0 && numBytes == data.length) { bzMid = data; } else { bzMid = new byte[numBytes]; for(int i = 0;i < numBytes;++i) { bzMid[i] = data[offset + i]; } } ContentValues contentValues = new ContentValues(); contentValues.put(DATA_BASE_RECORD_VALUE, bzMid); try { mSQLLiteDataBase.insert(mRMSName, null, contentValues); Cursor cursor = mSQLLiteDataBase.rawQuery("SELECT * FROM " + mRMSName, null); cursor.moveToLast(); recordID = cursor.getInt(cursor.getColumnIndex(DATA_BASE_RECORD_ID)); cursor.close(); //Fire added RecordListener fireAddedRecordListener(recordID); } catch(Exception e) { throw new Exception(); } } } else { throw new Exception(); } Return recordID; } Yevgeni http://www.UpOnTek.com -----Original Message----- From: android-developers@googlegroups.com [mailto:android-develop...@googlegroups.com] On Behalf Of Nithin Sent: Wednesday, December 16, 2009 13:55 To: Android Developers Subject: [android-developers] Re: SQlite Db problems Hi, If you are using images from the resource, just store the ID or use blob.. On Dec 16, 3:48 pm, MPS <bamas2...@gmail.com> wrote: > hai developers, > > i want to know how to store the images in SQLite database in > android.and also how to retrieve it. anyone give the samplecode or > any URL give me to develop my application. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en