ADO.NET Datatable to ITable

Discussion created by fhgnbi on Nov 15, 2011
Latest reply on Jun 13, 2012 by jamesfreddyc
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 ?