110,533
社区成员
发帖
与我相关
我的任务
分享
StringBuilder strSql = new StringBuilder();
strSql.Append(@"
select *
from tableName
where CreateDate>=@DateTime1 and CreateDate<@DateTime2 ");
SqlParameter[] parameters = {
new SqlParameter("@DateTime1", SqlDbType.DateTime),
new SqlParameter("@DateTime2", SqlDbType.DateTime)};
parameters[0].Value = date.Date;
parameters[1].Value = DateTime.Now.Date.AddDays(1);
DbHelperSQL.Query(strSql.ToString(), parameters);