Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <uses-permission android:name="android.permission.READ_CONTACTS" >
- </uses-permission>
- Cursor phones = getContentResolver().query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null,null,null, null);
- while (phones.moveToNext())
- {
- String name=phones.getString(phones.getColumnIndex(ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME));
- String phoneNumber = phones.getString(phones.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER));
- }
- phones.close();
- public class DatabaseHelper extends SQLiteOpenHelper {
- public static final String DATABASE_NAME = "EventBoard.db";
- public static final String EVENTS_TABLE = "Events";
- public static final String GUESTS_TABLE = "Guests";
- public DatabaseHelper(Context context) {
- super(context, DATABASE_NAME, null, 1);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL("create table " + EVENTS_TABLE + "( _id INTEGER PRIMARY KEY AUTOINCREMENT,Name TEXT,Time TEXT,Date TEXT,Venue TEXT,Contact TEXT,Description TEXT);");
- db.execSQL("create table " + GUESTS_TABLE + "(Name TEXT,Phone TEXT,Email TEXT);");
- createGuestsTable(this);
- }
- public void createGuestsTable(Context context){
- Cursor phones = context.getContentResolver().query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI,null,null,null,null);
- while(phones.moveToNext()){
- String name = phones.getString(phones.getColumnIndex(ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME));
- String phoneNumber = phones.getString(phones.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER));
- String email = phones.getString(phones.getColumnIndex(ContactsContract.CommonDataKinds.Email.ADDRESS));
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues contentValues = new ContentValues();
- contentValues.put("Name", name);
- contentValues.put("Phone", phoneNumber);
- contentValues.put("Email", email);
- db.insert(GUESTS_TABLE,null,contentValues);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement