
I am trying to work out if it is possible to populate a DataTable object in Dexterity using .NET Interop without having to create a connection setup window to store credentials and connection details. I do not think using a pass-thru SQL connection can do this because then you're locked into using the row by row SQL_FetchNext(). I could use System.Data.SQLClient right, but then I need to define the connection string and I don't know of a way in Dexterity to get all the correct components to build the string.
Your brainwaves are appreciated.
*This post is locked for comments
I have the same question (0)