Discussion Forums

What I need to do is render a layer of shapes where the color of each shape depends on a value in a table other than the shapefile dbf table. I need to do a join between the dbf table and this other table. e.g. suppose the layer being displayed is US Zips, and I have a table 'ZipColor' in SQLServer with columns 'ZIP' and 'color'. I want to be able to use the zip of each shape being rendered to get the color from the ZipColor table.

Is it possible to do this with MapSuite? It appears to me that I would have to use the SymbolCustomRenderer object to do this. Is taht right? If so, is there an example available using this class?

Thanks for any help you can give me.

I have explored this further, and am now trying to use the CustomDrawEXEventHandler for a CustomPoint for the layer that I am trying to draw. I have added a CustomField to the layer to contain the data I need to identify the color I want for each point in the layer.

The CustomDrawEXEventHandler has a recordNum parameter identifying which point in the layer to draw. I am using the layer.DataQuery method to get the data associated with the point I am trying to draw. Unfortunately, the CustomField I added does not appear to be included in the DataTable that returns from DataQuery.

Is that correct? Will the DataQuery method only return the fields in the .dbf file, and not the custom fields as well?

Thanks-

 Matt

I think the custom data is stored in a hashtable, and you can get the hashtable by layer.CustomFields[0].CustomData but not the DataQuery method. In your case the key of the hashtable may be the recordID in the dbf file, the corresponding value should be the color you got from SQL Server.