排序问题
我用AJAX做dropdownlist联动问题,在AjaxMethod.vb中,#Region "GetAreaList"
<Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)> Public Shared Function GetAreaList(ByVal zylbid As Integer) As DataSet
Dim sql As String = "select * from zyxx where zylbid=" & zylbid
Return GetDataSet(sql)
End Function
#End Region
可是在这里我想对表zyxx的数据进行按照zyxxid排序
如果是
Dim sql As String = "select * from zyxx order by zyxxid where zylbid=" & zylbid
这样写出来的结果是不对的,
一定要选执行了where 再执行order by
可是由于""的关系。。。无法在where 之后加上order by
有高手指点一下吗? --------------------编程问答-------------------- Dim sql As String = "select * from zyxx where zylbid=" & zylbid % " order by zyxxid "
--------------------编程问答-------------------- Dim sql As String = "select * from zyxx where zylbid=" & zylbid & " order by zyxxid "
--------------------编程问答-------------------- 楼上的,看你的写法挺对的,可是偶试了不行诶 --------------------编程问答-------------------- 要注意ORDER前要有空格
你输出你的SQL语句,看看问题所在,放到查询分析器中去执行调试
补充:.NET技术 , VB.NET