我有这个查询,当我在Sql studio上执行它时得到结果:
select TeamName, count(*)
from NetHoz_Decision
inner join NetHoz_Case on NetHoz_Decision.CaseDisplayIdentifier = NetHoz_Case.CaseDisplayIdentifier
inner join maintik on MainTik.Counter = NetHoz_Case.TikCounter
inner join Teams on MainTik.TeamCounter = Teams.Counter
where NetHoz_Decision.DecisionStatusChangeDate between '2015-07-23' and '2015-07-28'
group by TeamName
但是,当我在C#SqlCommand上执行它时,我没有得到任何结果。dataSet为空,我没有收到任何错误。我以为问题可能是过时的。我可以正确转换吗?
String date1 = String.Format("{0:yyyy-MM-dd}", dateTimePicker1.Value);
String date2 = String.Format("{0:yyyy-MM-dd}", dateTimePicker2.Value.AddDays(1));
const string query = "
select TeamName, count(*)
from NetHoz_Decision
inner join NetHoz_Case on NetHoz_Decision.CaseDisplayIdentifier = NetHoz_Case.CaseDisplayIdentifier
inner join maintik on MainTik.Counter = NetHoz_Case.TikCounter
inner join Teams on MainTik.TeamCounter = Teams.Counter
where NetHoz_Decision.DecisionStatusChangeDate between @from and @to
group by TeamName
";
SqlCommand command = new SqlCommand(query);
command.Parameters.AddWithValue("@from", dateTimePicker1.Value);
command.Parameters.AddWithValue("@to", dateTimePicker2.Value.AddDays(1));
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句