＋设为首页 ＋添加到收藏夹
oleDbDataAdapter1.SelectCommand.CommandText = "SELECT ID, Date, Summary, Debit_sum, Credit_sum, Balance_sum FROM Cash WHERE ((Date >= "+textBox5.Text+") && (Date <= "+textBox6.Text+"))";
我想在数据库中选择所有日期字段Date的值在textBox5和textBox6里输入的日期之间的记录，上面语句会选择把>=textBox6记录也选上，请问该如何改？
把 && 换成 and
"select id,data from cash where data BETWEEN " + textbox5.Text + "" and " + textbox6.text + ""
如果是Access数据库那么把改成#
在数据库SQL语句里面好像是没有&&的
只有AND;
用 BETWEEN AND ,最好带上时间,选记录会更精确
"SELECT ID, Date, Summary, Debit_sum, Credit_sum, Balance_sum FROM Cash WHERE Date BETWEEN "+textBox5.Text+" 00:00:00 AND "+textBox6.Text+" 23:59:59";
