Click here to Skip to main content
14,836,169 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

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?

thk
Posted
Comments
CHill60 22-Nov-13 8:22am
   
Have you tried anything yet? What problems are you having?
Lopezd 22-Nov-13 20:35pm
   
i have look in several web pages but i only find scripter form smo, but i don't want to use it.
CHill60 23-Nov-13 6:52am
   
However, you have answered one of your own questions ... it can be done! And you should be able to get some idea of how from the scripter you don't want to use. Have a go and come back with specific problems

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900