Hello users, is there a way to use an ADO.NET-Datatable as XY-Event-Layer ? The challenge is the dynamically link to this table, so if the underlying datatable is changed the XY-Event-Layer also changes. My problem is to find out, how I make the QueryInterface between Datatable and ITable like: Dim pTable As ITable Dim pDatatable As System.Data.DataTable ... fill the table ... pTable = pDatatable Any other suggestions are also welcome. I found examples to convert ITable to Datatable and vice versa, but I don't want to ceate temporary data. I also found ESRI.ArcGIS.Utility.Converter::ToDataSet to convert an ESRI-Recordset to ADO-Datatable, but where is something like ESRI.ArcGIS.Utility.Converter::FromDataSet ? I tried to make a XY-Event-Layer with IQueryName2, but it seems the SQL-Statement (whereclause) is restricted for simple queries (i. e. no joins possible). I found a similar question in the closed thread http://forums.esri.com/Thread.asp?c=2&f=1720&t=209789, but there is no solution. Can help anyone ?
... View more