how to retrieve and save(db) the date picker selected date

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to save the selected date in the database.
I did that with the help of date picker, now I need to save it in the database.

How to do that?
How to get the selected date and store it in the database?

Can any one help to me?

this is my code

C#

DatePickerDialog.OnDateSetListener startdate=new DatePickerDialog.OnDateSetListener() {
        public void onDateSet(DatePicker view, int year, int monthOfYear,
                int dayOfMonth) {
            dateAndTime.set(Calendar.YEAR, year);
            dateAndTime.set(Calendar.MONTH, monthOfYear);
            dateAndTime.set(Calendar.DAY_OF_MONTH, dayOfMonth);
        }
    };
TimePickerDialog.OnTimeSetListener t=new TimePickerDialog.OnTimeSetListener() {
        public void onTimeSet(TimePicker view, int hourOfDay,int minute) {
            dateAndTime.set(Calendar.HOUR_OF_DAY, hourOfDay);
            dateAndTime.set(Calendar.MINUTE, minute);
            view.setCurrentHour(Calendar.HOUR_OF_DAY);

        }
    };

///////////////
           super.onStart();
		dbHelper=new DatabaseActivity(this);
	        
	    	Button startbtn=(Button)findViewById(R.id.AddStartButton);
	    	startbtn.setOnClickListener(new View.OnClickListener() { 
				public void onClick(View v) { 
					new DatePickerDialog(AddTask.this,startdate, 
							dateAndTime.get(Calendar.YEAR), 
							dateAndTime.get(Calendar.MONTH), 
							dateAndTime.get(Calendar.DAY_OF_MONTH)).show(); 			
					} 
		 
	    	btn=(Button)findViewById(R.id.time);
        btn.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
                new TimePickerDialog(Alarm.this,t,
                        dateAndTime.get(Calendar.HOUR_OF_DAY),
                        dateAndTime.get(Calendar.MINUTE),
                        true).show();
                }
        });

	    	
	    	private DatePickerDialog.OnDateSetListener startdate = new DatePickerDialog.OnDateSetListener() {
	    		    		
	    		// onDateSet method
	    		public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
	    		String date_selected = String.valueOf(monthOfYear+1)+" /"+String.valueOf(dayOfMonth)+" /"+String.valueOf(year);
	    		Toast.makeText(AddTask.this, "Selected start Date is "+date_selected, Toast.LENGTH_SHORT).show();
	    			
	    		
	    		//Task date=new Task(date);
	    		//dbHelper.AddTask(date);
	    		
	    		}
	    		};   	
	    	
	   });

by this way am getting and toast the selected date

Thank you friends

Posted 19-Apr-11 21:08pm

ezhilsigamani

Updated 20-Apr-11 0:34am

v4

Add a Solution

Comments

Dalek Dave 20-Apr-11 3:32am

Edited for Grammar and Readability.

CookieMan90 1-May-12 9:26am

Hi, I was wondering, but how do you retrieve and display information from a database using DatePicker and TimePicker?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wannes Geysen · Answer 1 · 2011-04-19T23:36:00

Solution 2

select date from datetime picker is easy:

DateTime dateTime = datetimepicker.Value;

inserting this value in a SQL database can be done with SQLParameters:

_sqlConnection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(@"INSERT INTO Tablename(columnDateTimeName) VALUES (@DateTimeParam)",_sqlConnection);
cmd.Parameters.Add("@DateTimeParam", SqlDbType.DateTime).Value = dateTime;
cmd.ExecuteNonQuery();

Hope it helps you!

Posted 19-Apr-11 23:36pm

Wannes Geysen

Updated 19-Apr-11 23:37pm

v2

Comments

ezhilsigamani 20-Apr-11 6:00am

thank you fri... check my updated question by this way am using the datepicker ....

Wannes Geysen 20-Apr-11 6:20am

I don't get it. You aren't working with a dateTimePicker, but with a DatePickerDialog?

ezhilsigamani 20-Apr-11 6:37am

@wannes i need both datetime but i did't mention that thats it sorry

Sandeep Mewara · Answer 2 · 2011-04-19T22:04:00

Solution 1

How to do that?
Just like you save other data in database. Nothing different or new.

How to get the selected date
from the datepicker directly? No idea why or whats stopping you here.

Can any one help to me?
Looking for something else other than above? If Yes -> post what you are trying and are stuck, we will try to help.