We are trying to use AspMap for GIS BI solution that we are developing.
Solution is based on SHP files for performace issues. Inside DBF file only static feature attributes are added and we need to add more feature attributes dynamicly from database. Every report has different set of data, and also different user session can view different datasets.
Is there option to merge data feature attributes from SHP file (data stored in DBF) and external data loaded from Database? If there is how to do such thing.
We tried to write directly to DBF file and everything works, except this solution is only valid for one user scenario.
The Layer.AddRelate method can be used to attach data from databases.
The DemographicMap sample demonstrates how to use it.
This method is exactly what we where looking for. Currenty we have a problem, and that is return value of tihs method is always false.
What could be the reason for this?
FEAT_NUM is Id ove Region from SHP, DBF file, and "RegionId" is key from DataTableRegion.
var status = regionLayer.AddRelate("FEAT_NUM", DataTableRegion, "RegionId");
Please note that DataTableRegion is ADO.NET DataTable. We have complex DB infrastructure so using AspMap.DataSource is really not possible for us.
Is there a way to directly open already prepepared DataTable?
Make sure that you are using AspMap 4.8.2.
The previous versions do not support a DataTable as a parameter for the AddTable method.
New version actually support data from DataTable.