VDS Technologies

 

AspMap for reporting application

8/15/2013 5:08:59 AM
Total Posts 11

AspMap for reporting application

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.

8/15/2013 7:36:10 AM
MVP
Total Posts 323

Re: AspMap for reporting application

The Layer.AddRelate method can be used to attach data from databases.

The DemographicMap sample demonstrates how to use it.

8/15/2013 9:06:16 AM
Total Posts 11

Re: AspMap for reporting application

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");

8/15/2013 9:17:48 AM
Total Posts 11

Re: AspMap for reporting application

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?

8/15/2013 9:44:46 AM
MVP
Total Posts 323

Re: AspMap for reporting application

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.

8/20/2013 7:31:32 AM
Total Posts 11

Re: AspMap for reporting application

New version actually support data from DataTable.

Thx!