我需要获得DateTimePicker组件的值(比如visual本机DateTimePicker组件,基本上是相同的),并将其转换为变量DateTime在Mysql数据库中执行查询,这是使用此值查看该格式的最佳方法:
'2015-08-07'
yyyy-mm-dd有人能告诉我怎么做吗?
发布于 2015-08-07 14:39:19
private DateTime InitialDate;
private DateTime EndDate;
this.dataInicial = new DateTime(radDateTimePickerInitialDate.Value.Year, radDateTimePickerInitialDate.Value.Month, radDateTimePickerInitialDate.Value.Day);
this.dataFinal = new DateTime(radDateTimePickerEndDate.Value.Year, radDateTimePickerEndDate.Value.Month, radDateTimePickerEndDate.Value.Day);发布于 2015-08-11 04:02:29
这是一个Web表单实现..。
protected void btnMyButton_Click(object sender, EventArgs e)
{
if (!Page.IsValid) return; // Handle rdpMyDateTimePicker not having a selected date by using a RequiredFieldValidator control
if (rdpMyDateTimePicker.SelectedDate == null) return; // Proper form validation should always prevent this being null
var formattedDate = Convert.ToDateTime(rdpMyDateTimePicker.SelectedDate).ToString("yyyy-MM-dd");
// Now insert the formattedDate string as a parameter into your database query
}https://stackoverflow.com/questions/31878910
复制相似问题