Click here to Skip to main content
15,884,739 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
After getting time and date from date picker and time picker .I want to insert date and time separately in sqlite db .
final String name1=name.getText().toString();
		final String mobile_number1=mobile_number.getText().toString();
		final String home_number1=home_number.getText().toString();
		final String company_name1=company_name.getText().toString();
		final String jobtitle1=jobtitle.getText().toString();
		final String emailid1=emailid.getText().toString();
    	SimpleDateFormat formatter = new SimpleDateFormat("dd-MMM-yyyy");
    	String dateInString = setdate.toString();
    	String timeInString=settime.toString();
		Date date = null;
		Time time=null;

    	try {
     
    		//Date date;
			try {
				date = formatter.parse(dateInString);
				time=(Time) formatter.parse(timeInString);
			} catch (java.text.ParseException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
    		System.out.println(date);
    		System.out.println(formatter.format(date));
     
    	} catch (ParseException e) {
    		e.printStackTrace();
    	}
   db.addContact(new Contact_details(name1,mobile_number1,home_number1,company_name1,jobtitle1,emailid1,date,time));
   Toast.makeText(getApplicationContext(), ""+date+""+time, Toast.LENGTH_LONG).show();

code to create table in sqlite

C#
String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
                + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
                + KEY_Mobile_no + " TEXT" + KEY_Home_no+" TEXT"+ KEY_Emailid +" TEXT"+ KEY_Job_title +" TEXT"+ KEY_Company_name +" TEXT"+ KEY_Date +" DATE"+ KEY_Time +" TIME"+")";
        db.execSQL(CREATE_CONTACTS_TABLE);

code to insert into sqlite
void addContact(Contact_details contact) {
        SQLiteDatabase db = this.getWritableDatabase();
 
        ContentValues values = new ContentValues();
        values.put(KEY_NAME, contact.getName()); // Contact Name
        values.put(KEY_Mobile_no, contact.getMobile_number()); // Contact Mobile_number
        values.put(KEY_Home_no, contact.getHome_number());
        values.put(KEY_Emailid, contact.getEmail_id());
        values.put(KEY_Job_title, contact.getJob_title());
        values.put(KEY_Company_name,contact.getCompany_title());
        values.put(KEY_Date, contact.getSet_date().toString()) ;
        values.put(KEY_Time, contact.getSet_time().toString());
        
 
        // Inserting Row
        db.insert(TABLE_CONTACTS, null, values);
        //2nd argument is String containing nullColumnHack
        db.close(); // Closing database connection
    }

but i am getting unfortunately app stopped error.I dnt know where i have made error ?
Posted
Comments
YRoger 16-Sep-14 3:03am    
what is the error log?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900