一个sql语句

2005-05-17 11:29:05 99 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

andy19801210 墨衍会员 · AI 创作全网分发关注 + 加入社区

Rockchip RK3568实战：手把手教你调试I2S音频驱动（附ALSA设备树配置详解）本文提供Rockchip RK3568平台I2S音频驱动的实战调试指南。详细解析了从硬件连接到软件配置的全过程，重点涵盖ALSA驱动框架下的设备树配置、时钟计算、DMA参数设置以及常见问题（如无声、爆音）的排查与解决方法，帮助开发者快速定位并解决音频驱动难题。阅读详情

我的sql语句是这样写的，但怎么在报表中显示不出时间呢？
sqlStr = "SELECT SUM(CAST(BUY_NUM AS numeric)) AS buy_num, SUM(CAST(MONEY AS NUMERIC)) AS money, " +" COUNT(USER_NO) AS COUNT, max(B_DATE) FROM M_BUYDETAIL WHERE ";
if( i == 1 )
for_year = Convert.ToString(int.Parse(cboYear.Text) - 1);
else
for_year = cboYear.Text;
sqlStr += "b_date between '" + for_year + reader["datestar"].ToString() + "' and '" + cboYear.Text + reader["dateend"].ToString() + " 23:59:59'";
reader.Close();
SqlDataAdapter da = new SqlDataAdapter(sqlStr, sg_mainForm.m_connStr);
da.Fill(dsSum, "BuyTotal");
MessageBox.Show(dsSum.BuyTotal[i].ToString());

crReportDocument.SetDataSource(dsSum);
crv.ReportSource = crReportDocument;

...全文