°ïæ¿´¿´ÕâÌõsqlÓï¾ä - .NET¼¼Êõ / ASP.NET

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or key like '%"+"ÊÇ"+"%' ";
Ìáʾkey¹Ø¼ü×Ö¸½½üÓдíÎó¡£

---

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or key like '%"+"ÊÇ"+"%' ";
Ìáʾkey¹Ø¼ü×Ö¸½½üÓдíÎó
Äã¸ø¶¨µÄÌõ¼þÂß¼­ÓÐÎÊÌâ

---

¹ÛÍûÂ¥Ö÷µÄ½áÌùÂÊ

---

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'or [key] like '%"+"ÊÇ"+"%' ";

---

2 3 Â¥ ¶¼ÕýÈ·

---

ºÃÁË£¬Ð»Ð»kuroroloveÁË

---

ÒýÓÃ

keyÊÇsql±£Áô¹Ø¼ü×Ö£¬±ðÓÃËüµ±Êý¾Ý¿â×Ö¶ÎÃû

ͬÒâ

---

KeyÊÇSQL ±£Áô¹Ø¼ü×Ö£¡

---

°ï¶¥£¡£¡£¡£¡£¡£¡£¡£¡£¡

---

[key]

---

key¶¼ÓÃÉÏÁË£¬Àúº¦

---

key ÊÇsql ±£Áô×Ö ÄãºóÃæÄǾä orÌõ¼þ¸ø¸öÀ¨ºÅ

---

ÒýÓÃ

string selectSql = "select * from class_user_xpnews where spmc like '%" + this.txtSpName.Text.Trim() + "%' and sssq='" + businessSquareId + "' and zxqk='" + fitmentid + "'o