读书人

绑定DropDownList去掉反复值

发布时间: 2011-12-11 23:19:43 作者: rapoo

绑—ropDownList去掉重复值
从表中绑定某个字段,但有重复值,请问怎么去掉

[解决办法]
试试把设为主键,
SELECT a.FreID, a.FreightWay
FROM freightLogAS a INNER JOIN
(SELECT MIN(FreID) AS id
FROM freightLog
GROUP BY FreightWay ) AS b ON a.FreID= b.FreID

读书人网 >asp.net

热点推荐