ArcEngine 结合sql语句查询示例

                // 正常查询条件
                IQueryFilter pQueryFilter = new QueryFilter();
                pQueryFilter.SubFields = "gridcode,pgridcode";
                pQueryFilter.WhereClause = string.Format("pgridcode='{0}'", pgridcode.ToString());

                //sql条件  排序
                IQueryFilterDefinition pQueryFilterDefinition = pQueryFilter as IQueryFilterDefinition;
                pQueryFilterDefinition.PostfixClause = "order by gridcode desc";//sql语句
                // 要素游标
                IFeatureCursor pFeatureCursor = cfeatureclass.Search(pQueryFilter, true);
                IFeature pFeature = pFeatureCursor.NextFeature();