c#sql语句时间的书写

方法1：  # " + 时间+ "# 

//满足的条件
string batch = " and  msg  like  " +"'" + "%" + txbRfidSel + "%" + "'";

//查询一个时间范围内满足的条件
string sql = $"select * from t_Log where   dataTime  between  # " + dataTime1 + "# and  #" + dataTime2 + "#"+ batch + "";


//调用方法

DataTable data = F_Data.ExeData(sql);

   

                 
方法2：'{时间}'

string sql = $"select * from t_RFIDInfo where  createDate between '{dataTime1}' and   '{dataTime2}' ";

DataTable data = F_Data.ExeData(sql);