string Key string sql="SELECT * FROM tb_User u,tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";
string Key string sql="SELECT * FROM tb_User u,tb_News n WHERE u.Name Like ’%"+Key+"%' AND u.FirstName like '%"+Key+"'%";
SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE'%' + KeyWord + '%' AND a.Description LIKE'%' + KeyWord + '%' AND a.Broadcast LIKE'%' + KeyWord + '%' AND a.Name LIKE'%' + KeyWord +'%' AND n.NovName LIKE'%' + KeyWord + '%' ORDER BY a.CreatTime DESC" 求解....
你用inner join 查询一下试试三张表联合查询
你的看清一楼给你解决方法形式 你这样当然是不对 人家是在一个字符串里 string sql = "SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE '%" + KeyWord + "'% AND a.Description LIKE '%" + KeyWord + "'% AND a.Broadcast LIKE '%" + KeyWord + "'% AND a.Name LIKE '%" + KeyWord + "'% AND n.NovName LIKE '%" + KeyWord + "'% ORDER BY a.CreatTime DESC";
string Key string sql="SELECT * FROM tb_User u,tb_News n WHERE 1=1" sql+=" AND u.Name Like ’%"+Key+"%'"; sql+=" AND AND u.FirstName like '%"+Key+"'%"; 就这样写好了 下边你懂的
写错了 呵呵 不好意思 string sql = "SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE '%" + KeyWord + "%' AND a.Description LIKE '%" + KeyWord + "%' AND a.Broadcast LIKE '%" + KeyWord + "%' AND a.Name LIKE '%" + KeyWord + "%' AND n.NovName LIKE '%" + KeyWord + "%' ORDER BY a.CreatTime DESC";
string sql="SELECT * FROM tb_User u,tb_News n WHERE u.Name Like ’%"+Key+"%' AND ... ";
string sql="SELECT * FROM tb_User u,tb_News n WHERE u.Name Like ’%"+Key+"%'
AND u.FirstName like '%"+Key+"'%";
求解....
你的看清一楼给你解决方法形式 你这样当然是不对 人家是在一个字符串里 string sql = "SELECT * FROM tb_Album a,tb_Category c, tb_Novels n WHERE a.CateID=c.CategoryID AND a.AlbumID=n.AbID AND c.CateName LIKE '%" + KeyWord + "'% AND a.Description LIKE '%" + KeyWord + "'% AND a.Broadcast LIKE '%" + KeyWord + "'% AND a.Name LIKE '%" + KeyWord + "'% AND n.NovName LIKE '%" + KeyWord + "'% ORDER BY a.CreatTime DESC";
string sql="SELECT * FROM tb_User u,tb_News n WHERE 1=1"
sql+=" AND u.Name Like ’%"+Key+"%'";
sql+=" AND AND u.FirstName like '%"+Key+"'%";
就这样写好了 下边你懂的