string sql = "select top 5 * from Dcms_Intro where Intro_CateId=931 order by cint(Intro_ExFlag5) desc " ;// 这样才能正确排序 cint(Intro_ExFlag5) //文本类型转换为数字类型