How to build Query dynamically using asp.net3.5 and c#.net

Question

i need create query dynamically in my .cs page. Actually what happens in my application is user can pass the column name and Table names from the page. by using those parameters(columns and tables) we need build Select query . we need retrieve those values from database and show in text format to user.there may multiple table and single table have multiple columns also.

please try yo help how to do this ny using asp.net3.5 and c3.net

Toon Krijthe · Accepted Answer · 2012-10-30 07:57:17Z

2

So you need to have a dynamic query that populates its columns as per users requirement. It is not achievable but I have a nearby solution of it.

You can specify from which tables you want data and then using system functions create dynamic query of yours and get it done.

edited Oct 30, 2012 at 7:57

Toon Krijthe

53.6k38 gold badges151 silver badges204 bronze badges

answered Oct 30, 2012 at 7:39

Kuldeep Patel

212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonathan Wood · Accepted Answer · 2010-12-24 06:26:59Z

0

If nothing else, just create the query string dynamically and then pass it to the ADO.NET routines.

string qry = String.Format("SELECT {0} FROM Table", colName);

answered Dec 24, 2010 at 6:26

Jonathan Wood

68.2k86 gold badges312 silver badges542 bronze badges

4 Comments

santhosh Over a year ago

hi thanks but my user can pass multiple columns from single table or multiple tables.i need to take all the value from multiple tables Ex: Cust Id from customers and Store Id from ,store address from Stores So i need to take 3 coloumn values from 2 table or more some times how it can be done?

Jonathan Wood Over a year ago

I don't understand what you are asking. I was just showing an example since you haven't been that specific. Are you asking how to modify a string so that it has the right query. Where are you getting stuck exactly?

santhosh Over a year ago

Actualy i unable to bind multiple columns from multiple table and unable join multiple tables dynamically. iam getting deatails from user is coloumn nams and tables names only by using those i need to retrieve values and shown to the Users.

RPM1984 Over a year ago

@santhosh - it is very bad design to have the user the ability to select which columns/tables they want to query upon. What if they type SELECT 1 GO DROP TABLE Customers?? If you want to give the user this much control, at least use something like a GridView.

Collectives™ on Stack Overflow

How to build Query dynamically using asp.net3.5 and c#.net

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related