Query Designer

[baeza]

this may be a dumb question, but i developed an application and my boss knows a little bit of sql so he wants me to create a program where he can choose the tables and relations and so on, just like a query designer in sql server or others and display the data.

my question is does anybody know a control | ocx | dll to do that?

btw my application is in vb.net.03

regards,

 

[mjb3030]

Does he want to select the tables visually, like in the query designer, or just write SQL commands?

 

[baeza]

Does he want to select the tables visually, like in the query designer, or just write SQL commands?

yes, he wants to do it all visually just like in SQL Enterprise manager, i wish he just wanted to write sql sentences. It's like a whim that he has.

I was thinking since visual studio .net has that functionality already, there must be a com to do that and that i might be able to use it, but which one?

thanks

 

[mjb3030]

Found a commercial one. http://www.programmersheaven.com/zone28/cat1013/41907.htm . Tell him it would cost more in man hours for you to make it yourself than it would to spend the $249

 

[baeza]

Found a commercial one. http://www.programmersheaven.com/zone28/cat1013/41907.htm . Tell him it would cost more in man hours for you to make it yourself than it would to spend the $249

good find! downloading it now if good enough i'll make him buy it for me. and call it a day

Thanks!