C#winform sql查询数据库，提示： 从字符串转换日期和/或时间时，转换失败。
DateTime Tmpstart = DateTime.Parse(StartData.Value.ToString("yyyy/MM/dd 0:00:00"));
DateTime Tmpend = DateTime.Parse(EndData.Value.ToString("yyyy/MM/dd 23:59:59"));
//string Tmpstart = StartData.Value.ToString();
// string Tmpend = EndData.Value.ToString();
string MySelect = "select 租赁时间,租金 from GuiderData where 租赁时间 > 'Tmpstart' and 租赁时间< 'Tmpend' ";
consql.Open();
/*SqlCommand sqlcmd = new SqlCommand(MySelect,consql);
sqlcmd.ExecuteNonQuery();*/
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(MySelect, consql);
da.Fill(ds);
RentData.DataSource = ds.Tables[0];
[解决办法]
直接写
DateTime Tmpstart = StartData.Value.Date;
DateTime Tmpend = EndData.Value.Date.AddDays(1).AddMinutes(-1);
不用写
DateTime Tmpstart = DateTime.Parse(StartData.Value.ToString("yyyy/MM/dd 0:00:00"));
DateTime Tmpend = DateTime.Parse(EndData.Value.ToString("yyyy/MM/dd 23:59:59"));
[解决办法]
"select * from users where 租赁时间 between @Tmpstart and @Tmpend"
这样写就可以了
[解决办法]
"select 租赁时间,租金 from GuiderData where 租赁时间 > '"+Tmpstart+"' and 租赁时间< '"+Tmpend+"' ";
