System.Data.SqlClient.SqlException: 操作数类型冲突: date 与 int 不兼容
select * from CX_News where CXdate< shixiaoDate在数据库新建查询时没问题的 


 可是在后台里 string where = " chakancishu > CXdate and Is_show=1 ";
 string fieldList = "CXID,CXContent,CXkeywords,CXtitle,CXdate,Is_show,order_by,img,faburen,shixiaoDate,chakancishu";
  string orderField = "order_by";
  bool orderBy = true;

  DataRecordTable table = new CX_NewsBussiness().GetList(fieldList, orderField, orderBy, 1, 20, where.ToString());
  gwCuXiao.DataSource = table.Table;
  gwCuXiao.DataBind();
这样写就有问题了 报错

什么情况？string where 是条件

------解决方案--------------------
Is_show是什么類型