asp.net中搜索绑定问题请大家快快帮忙给个思路呀！！！
sql= "select id as id,gjzname as title,webcontent as content,weburl as http,addtime as addtime,price as onclick,1 as type,yhid as hyid form s_gjz where gjzname= ' "+searchkey+ " ' ";
sql=sql+ "UNION ALL ";
sql=sql+ "select id as id,title as title,content as content,http as http,addtime as addtime,onclick as onclick,0 as type,0 as hyid from jxsbss where ifzdlr= '2 ' and title LIKE '% "+searchkey+ "% ' ";
sql=sql+ " order by type desc,onclick desc,addtime desc ";
adapter=new SqlDataAdapter (sql,con);
adapter.Fill(ds,startindex,psize, "jxsbss ");
<asp:Repeater ID= "showkeyinfo " runat= "server ">
<itemtemplate>
</itemtemplate>
</asp:repeater>
作用，同时显示两个表里的内然后绑定到Repeater 的控件显示数据
这样显示是否正确，如果不正确请大家给于指示
[解决办法]
Click the link to solve your problem.Good luck!
