I had created a layout in android which consist of date picker and display date in textbox. I want to store that date to database, i had created database, but the error occurs while fetching that date from text box. How can i store the selected date?
public class Welcome_Coordinator extends Activity implements OnClickListener{
boolean flag=false;
SQLiteDatabase db=null;
Button btnCalendar, btnTimePicker;
EditText txtDate, txtTime;
private int mYear, mMonth, mDay;
@SuppressLint("SimpleDateFormat")
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.welcome_coordinator);
btnCalendar = (Button) findViewById(R.id.btnCalendar);
txtDate = (EditText)findViewById(R.id.txtDate);
btnCalendar.setOnClickListener(this);
db=openOrCreateDatabase("schooldata", MODE_PRIVATE, null);
db.execSQL("create table if not exists employee(txtDate varchar,flag varchar)");
}
@Override
public void onClick(View v) {
if (v == btnCalendar) {
// Process to get Current Date
final Calendar c = Calendar.getInstance();
mYear = c.get(Calendar.YEAR);
mMonth = c.get(Calendar.MONTH);
mDay = c.get(Calendar.DAY_OF_MONTH);
// Launch Date Picker Dialog
DatePickerDialog dpd = new DatePickerDialog(this,
new DatePickerDialog.OnDateSetListener() {
@Override
public void onDateSet(DatePicker view, int year,
int monthOfYear, int dayOfMonth) {
// Display Selected date in textbox
txtDate.setText(dayOfMonth + "-"
+ (monthOfYear + 1) + "-" + year);
}
}, mYear, mMonth, mDay);
dpd.show();
}
}
public void action(View v)
{
switch(v.getId())
{
case R.id.button1:
//I am getting an error here
String txtDate=txtDate.getText().toString();
{
db.execSQL("insert into employee values('"+txtDate+"', 'nothing')");
overridePendingTransition(R.anim.slide_in_right, R.anim.slide_out_left);
db.close();
finish();
}
break;
}
Toast.makeText(getApplicationContext(), "Submitted Successfully", Toast.LENGTH_LONG).show();
}
Please help me. Thank you.
Aucun commentaire:
Enregistrer un commentaire