使用C＃usind datetime picker从SQL中选择数据 [英] select data from SQL with C# usind datetime picker

问题描述

我想从数据库中选择记录，其中date = date在datetimepicker中我正在使用这个但是出现错误从字符串转换日期/时间时转换失败。



datetimepicker格式为long，日期列的SQL数据类型为date



SqlDataAdapter com = new SqlDataAdapter（select * from Farmers where Date = + dateTimePicker1.Value.Date +，con）;

DataSet ds = new DataSet（Farmers）;

con.Open（）;

com.Fill（ds）;

con.Close（）;

I want to select records from data base where date = date in datetimepicker I''m using this but Error occurs "Conversion failed when converting date/time from character string".

datetimepicker format is "long" and in SQL datatype of Date Column is date

SqlDataAdapter com = new SqlDataAdapter("select * from Farmers where Date="+dateTimePicker1.Value.Date+"", con);
DataSet ds = new DataSet("Farmers");
con.Open();
com.Fill(ds);
con.Close();

推荐答案

更改日期列的数据类型SQL到datetime并将dateTimePicker1.Value保留为默认设置



使用：



SELECT * FROM表WHERE Date =''+ Convert.ToDateTime（dateTimePicker1.Value）'';

Change the DataType of the date column in SQL to datetime and leave the dateTimePicker1.Value to default settings

use:

"SELECT * FROM Table WHERE Date= ''" + Convert.ToDateTime(dateTimePicker1.Value)'' ";

使用参数化查询i nstead：

Use a parametrised query instead:

SqlDataAdapter com = new SqlDataAdapter("SELECT * FROM Farmers WHERE Date=@DT", con);
com..SelectCommand.Parameters.AddWithValue("@DT", dateTimePicker1.Value.Date);
DataSet ds = new DataSet("Farmers");
con.Open();
com.Fill(ds);
con.Close();

这篇关于使用C＃usind datetime picker从SQL中选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！