Ticket #2795: Program.cs

using System;
using System.Collections.Generic;
using System.Text;
using OSGeo.MapServer;

namespace mssql2008Test
{
    class Program
    {
        static void Main(string[] args)
        {
            mapObj map = new mapObj(@"E:\projects\mssql2008\bin\test2008.map");
            layerObj layer = map.getLayer(0);
            layer.queryByAttributes(map, null, "((ID=26124) or (ID=35906))", 1);

            using (resultCacheObj results = layer.getResults())
            {
                if (results != null && results.numresults > 0)
                {
                    // extracting the features found
                    layer.open();

                    resultCacheMemberObj res;
                    shapeObj shape;

                    System.Text.UTF8Encoding encoding = new System.Text.UTF8Encoding();

                    for (int j = 0; j < results.numresults; j++)
                    {
                        res = results.getResult(j);
                        shape = layer.getFeature(res.shapeindex, res.tileindex);
                        if (shape != null)
                        {
                            Console.WriteLine("\nFeature, OID=" + res.shapeindex);
                            
                            for (int k = 0; k < layer.numitems; k++)
                            {
                                Console.WriteLine("   " + layer.getItem(k) + " = " + shape.getValue(k));
                            }
                        }
                    }
                    layer.close();
                }
            }
        }
    }
}