SQL ASP.net Select OR 语句 下面这句查询字符哪儿写错了？

Question

string sqlstr = "select SortOrder,Remarks,Contactor,ContractNum,ContractDL,Delivery,WorkOrderNum from View_Product where (CONVERT(varchar(10), OrderTime, 23) like'" + ViewState["SearchDate"].ToString() + "%') OR (WorkOrderNum ='" + ViewState["SearchStr"].ToString() + "') OR (DrawNum ='" + ViewState["SearchStr"].ToString() + "') Order by SortOrder";

Answer 1

目测没问题，你什么错吗？还是数据不对啊追问

追答

亲，未将对象引用到实例是程序错误，不是sql错误，
你调试一下，可能是ViewState["SearchDate"]或ViewState["SearchStr"]未被初始化就被你拿来用了