Last post Apr 09, 2012 02:30 PM by TabAlleman
Oct 31, 2011 06:23 AM|Saurabh Nawathe|LINK
Nov 02, 2011 03:49 AM|Chen Yu - MSFT|LINK
Do you means you want to create a dynamic SQL Query? If so, this thread may help you.
Hope it helps.
Nov 02, 2011 07:40 AM|Saurabh Nawathe|LINK
Hi i have developed a application where iam dragging and dropping table and automatially if the two tables are having relation then inner join query is generated and if they do not have relation then automatically cross join is generated but currently it
is working for only two tables so i want to develop a SQl Query Builder in ASP.net where a user will drag drop many tables and automatically correct query will be genarated just like SQL Server Management studio does. Please help me as soon as you can.
Nov 02, 2011 10:30 AM|Chen Yu - MSFT|LINK
Do you means you want to create a class or something else to achieve SQL Query builder?
Nov 09, 2011 04:35 AM|Saurabh Nawathe|LINK
I want to create a SQL Query Builder in C#.net using class or any other technique where i can drag drop tables and if they are having relationship then automatically inner join query would be created otherwise cross join would be created. The table names
are not known at runtime the user can drag and drop any tables at anytime then i have to identify whether relationship exists or not and return the generated string accordingly.
Apr 09, 2012 10:31 AM|MMOHANMSC|LINK
Am a beginner in ASP.net.. I too made some R&D in Designing a Custom SQL QueryBuilder.. Can u please help me with the codes that you developed for the Query Editor. so that i can also know what i actually want to do.?
Apr 09, 2012 02:30 PM|TabAlleman|LINK
See the query in this article:
You can use the 2 tables you want to check to make a WHERE clause to find out if a relationship exists between those two tables.