c# 我想要选择日期时间显示水晶报告的位置，但不显示数据

Question

myConnection = new SqlConnection(cs.DBConn);
MyCommand.Connection = myConnection;
MyCommand.CommandText = "select * from vwProfit Where OrderDateGet= '" + dateTimePicker1.Value.ToString() + "'";
MyCommand.CommandType = CommandType.Text;
myDA.SelectCommand = MyCommand;
myDA.Fill(myDS, "vwProfit");
rpt.SetDataSource(myDS);
frm.crystalReportViewer1.ReportSource = rpt;
frm.Show();

谁可以编辑代码我，我想选择日期的位置，但不显示数据

Answer 1

以

相同的格式转换两个日期时间，然后尝试。

MyCommand.CommandText = "select * from vwProfit Where Convert(varchar,OrderDateGet,103)= convert(varchar,'" + dateTimePicker1.Value.ToString() + "',103)";