I have 2 treeviews, the first one shows the source database with tables and columns, the second shows a structure of items that will be used in a dashboard, basicaly i associate values from the database with that structure, and generate a querie that connects both items.
I want to create a script object and add all sql queries in it.
since i want that my program works with several database types (SQLServer, MySql, ODBC,...) i need to generalize it.
Can it be done? How?