I am using an SDK with an ERP system that allows me to make use of SQL Views that are canned within the application. I declare the view like so:
Dim edvCurrentWork As EpiDataView = CType(oTrans.EpiDataViews("CurrentWork"), EpiDataView)
I need to take this view I declared and bound the results to a DataTable to be able to make use of later on with a MERGE option. Ultimate goal would would be have 2 of these "EpiDataView"s and merge them together to bound the data to a native .NET 2.0 datagrid.
Any help with how to use this dataview and bound it to a DataTable would be VERY much appreciated as there is no connection string, etc becaue the view and the data is essentially already there if that makes sense.