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 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"));
这样写就可以了