将字符串转换为smalldatetiem数据类型时转换失败。 [英] Converting failed when converting character string to smalldatetiem data type.

问题描述

我有这个错误过滤日期字段。



这是代码。

Hi I have this error filtering date field.

This is the code.

string filtro = "";

filtro += "and CAST(DATEDIFF(DAY, 0, FechaEntrada) AS DATETIME)  <=  ' " + Convert.ToDateTime(dateTimePicker1.Text) + " ' ";
DataSet ObjDataSet = new DataSet();
SqlDataAdapter objAdap = new SqlDataAdapter("SELECT * FROM lstEntrada WHERE (Estatus = 'ACTIVO')" + filtro + "  order by fechaentrada ", System.Configuration.ConfigurationSettings.AppSettings.Get("cadenaconnect"));
objAdap.Fill(ObjDataSet, "lstEntrada");
RepEntrada3 opt = new RepEntrada3();
opt.SetDataSource(ObjDataSet.Tables[0]);
crystalReportViewer1.ReportSource = opt

推荐答案

嗨再次!!，



解决方案是将窗口的日历设置从dd / MM / yy更改为dd-MM-yy

Hi again!!,

The solution was change the calendar settings of windows from dd/MM/yy to dd-MM-yy

这篇关于将字符串转换为smalldatetiem数据类型时转换失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！