Asp.net 鏈接mySQL 使用like查詢(xún)mysql 查詢(xún)器中正常 asp.net 返回沒(méi)有結(jié)果，問(wèn)各位大神這是為什么？
2 回答
12345678_0001
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超5個(gè)贊
StringBuilder sb = new StringBuilder();
sb.Append("select * from Friend_UserSiteInfo where IsDel=0");
StringBuilder sbCondition = new StringBuilder(); if (friendID != 0)
{
sbCondition.AppendFormat(" AND FriendID={0}", friendID);
} if (!string.IsNullOrEmpty(friendSiteName))
{
sbCondition.AppendFormat(" AND FriendSiteName Like '%{0}%'",friendSiteName);
} if (type !=0)
{
sbCondition.AppendFormat(" AND CooperationMode ={0}", type);
}
sb.Append(sbCondition.ToString());
sb.AppendFormat(" limit {0},{1} ;", ((pageIndex - 1) * pageSize), pageIndex * pageSize);
sb.Append(" SELECT COUNT(0) FROM Friend_UserSiteInfo WHERE IsDel=0 ");
sb.Append(sbCondition.ToString());
達(dá)令說(shuō)
TA貢獻(xiàn)1821條經(jīng)驗(yàn) 獲得超6個(gè)贊
sb.Append(sbCondition.ToString());
sb.AppendFormat(" limit {0},{1} ;", ((pageIndex - 1) * pageSize), pageIndex *pageSize);把這個(gè)sb.Append(sbCondition.ToString());刪除掉試試。寫(xiě)了兩次了，把第一個(gè)刪除掉。
添加回答
舉報(bào)
0/150
提交
取消