MapXtreme2004代码 搜索特定图元并将其显示到地图上

private void showMap()

{

     MIDataReader tr;

     MIConnection con=new MIConnection();

     MICommand tc=con.CreateCommand();

 

     tc.CommandText="select 村 from 农安 where PH__2002 > 8.5";

     //sql语句

     con.Open();

 

     IFeatureCollection fc = tc.ExecuteFeatureCollection();

     //得到Features集合

 

     tr=tc.ExecuteReader();

     while (tr.Read())

     {

         Response.Write(tr.GetString(0)+" ");

         //显示搜索到的信息

     }

 

     tc.Cancel();

     tc.Dispose();

     tr.Close();

     con.Close();

 

     IResultSetFeatureCollection ff = (IResultSetFeatureCollection)fc;

     //强行转化为IResultSetFeatureCollection

 

     if (MapInfo.Engine.Session.Current.Selections.DefaultSelection.Style.AreaStyle.Interior is SimpleInterior)

     {

         ((SimpleInterior)MapInfo.Engine.Session.Current.Selections.DefaultSelection.Style.AreaStyle.Interior).BackColor = Color.Red;

         //更改DefaultSelection的背景颜色

     }

 

     MapInfo.Engine.Session.Current.Selections.DefaultSelection.Clear();

     MapInfo.Engine.Session.Current.Selections.DefaultSelection.Add(ff);

     //添加到DefaultSelection中 用户可见到效果

}