UC知道sqldatasource自定义sql语句
来源：百度知道 编辑：UC知道 时间：2024/09/22 07:25:52
我在查询分析器写的
sql语句为
select l_title,l_author from Life where l_year='2008' and l_month='4' and (l_category in ('Research Paper','研究论文'))
显示该条件的文章列表
但在sqldatasource里面写`就显示不出来
代码为：SELECT [l_Title], [l_Author] FROM [Life] WHERE (([l_Year] = @l_Year) AND ([l_Month] = @l_Month) AND ([l_Category] IN (@l_Category,@l_Category2))
请高手赐教
sql语句为
select l_title,l_author from Life where l_year='2008' and l_month='4' and (l_category in ('Research Paper','研究论文'))
显示该条件的文章列表
但在sqldatasource里面写`就显示不出来
代码为：SELECT [l_Title], [l_Author] FROM [Life] WHERE (([l_Year] = @l_Year) AND ([l_Month] = @l_Month) AND ([l_Category] IN (@l_Category,@l_Category2))
请高手赐教
SELECT [l_Title], [l_Author] FROM [Life] WHERE (([l_Year] = @l_Year) AND ([l_Month] = @l_Month) AND ([l_Category] IN (@l_Category,@l_Category2))
是给sql用传入参数的方式进行的,故不能用控件sqldatasource
你可以参考：http://topic.csdn.net/u/20070327/20/36430f07-6c08-4614-ab9b-a00ce16804c3.html?744918647