如何检索和保存(db)日期选择器选择的日期 [英] how to retrieve and save(db) the date picker selected date

问题描述

我正在尝试将所选日期保存在数据库中.
我是在日期选择器的帮助下完成的，现在我需要将其保存在数据库中.

怎么做?
如何获取所选日期并将其存储在数据库中?

有人可以帮我吗?


这是我的代码

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

<pre lang="cs">DatePickerDialog.OnDateSetListener startdate=new DatePickerDialog.OnDateSetListener() {<br />
        public void onDateSet(DatePicker view, int year, int monthOfYear,<br />
                int dayOfMonth) {<br />
            dateAndTime.set(Calendar.YEAR, year);<br />
            dateAndTime.set(Calendar.MONTH, monthOfYear);<br />
            dateAndTime.set(Calendar.DAY_OF_MONTH, dayOfMonth);<br />
        }<br />
    };<br />
TimePickerDialog.OnTimeSetListener t=new TimePickerDialog.OnTimeSetListener() {<br />
        public void onTimeSet(TimePicker view, int hourOfDay,int minute) {<br />
            dateAndTime.set(Calendar.HOUR_OF_DAY, hourOfDay);<br />
            dateAndTime.set(Calendar.MINUTE, minute);<br />
            view.setCurrentHour(Calendar.HOUR_OF_DAY);<br />
<br />
        }<br />
    };<br />
<br />
///////////////<br />
           super.onStart();<br />
		dbHelper=new DatabaseActivity(this);<br />
	        <br />
	    	Button startbtn=(Button)findViewById(R.id.AddStartButton);<br />
	    	startbtn.setOnClickListener(new View.OnClickListener() { <br />
				public void onClick(View v) { <br />
					new DatePickerDialog(AddTask.this,startdate, <br />
							dateAndTime.get(Calendar.YEAR), <br />
							dateAndTime.get(Calendar.MONTH), <br />
							dateAndTime.get(Calendar.DAY_OF_MONTH)).show(); 			<br />
					} <br />
		 <br />
	    	btn=(Button)findViewById(R.id.time);<br />
        btn.setOnClickListener(new View.OnClickListener() {<br />
            public void onClick(View v) {<br />
                new TimePickerDialog(Alarm.this,t,<br />
                        dateAndTime.get(Calendar.HOUR_OF_DAY),<br />
                        dateAndTime.get(Calendar.MINUTE),<br />
                        true).show();<br />
                }<br />
        });<br />
<br />
	    	<br />
	    	private DatePickerDialog.OnDateSetListener startdate = new DatePickerDialog.OnDateSetListener() {<br />
	    		    		<br />
	    		// onDateSet method<br />
	    		public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {<br />
	    		String date_selected = String.valueOf(monthOfYear+1)+" /"+String.valueOf(dayOfMonth)+" /"+String.valueOf(year);<br />
	    		Toast.makeText(AddTask.this, "Selected start Date is "+date_selected, Toast.LENGTH_SHORT).show();<br />
	    			<br />
	    		<br />
	    		//Task date=new Task(date);<br />
	    		//dbHelper.AddTask(date);<br />
	    		<br />
	    		}<br />
	    		};   	<br />
	    	<br />
	   });	   <br />
<br />
</pre><br />

通过这种方式来获取和敬酒所选日期


谢谢朋友

by this way am getting and toast the selected date


Thank you friends

推荐答案

从日期时间选择器中选择日期很容易:

select date from datetime picker is easy:

DateTime dateTime = datetimepicker.Value;

可以使用SQLParameters在SQL数据库中插入该值:

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!

该怎么做?
就像您将其他数据保存在数据库中一样.没什么不同或新的.

如何获取所选日期
从日期选择器直接?不知道为什么或什么阻止了你在这里.

有人可以帮助我吗?
寻找以上以外的东西吗?如果是->发布您正在尝试并遇到的问题，我们将尽力提供帮助.

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.

这篇关于如何检索和保存(db)日期选择器选择的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！