Hi all,

I am developing a web application(using asp.net + C#) where I have a checkboxlist of columns in a table(on SQL server). Lets suppose there is a table customer_info with columns: name, address,phone, website etc.
So, my checkboxlist would list all the columns in the table. User can select one or more columns to display. Suppose user chooses only name and phone number to be displayed then While displaying the records, I must only display the requested columns to the user. The choice can vary each time. How do I do this using stored procedure.

I have collected the selected columns by the user as a comma -separated variable: Eg: @columns would get value like 'name, address' for above example.

But when I use the query
SELECT @columns FROM customer_info

it displays something like this

name address
name address
name address
... and so on. It doesn't display the actual value of the columns.

Any help regarding this problem will be greatly appreciated.

Thanks!!!

__________________
durgesh

taht is becauase the query framed by you at runtime selects the text wrongly provided by you not the actual data from the desired columns. You need to reframe your queery properly at run time.

Regards
Debasis

Hi,
Any solution to this problem.


Thanks,

You can't pass the list as a parameter.

You need to, instead, create an "ad hoc" SQL query that uses the list of values from the checkboxes. That is, create a C# String that *is* the SQL query.

String sql = "SELECT " + listOfCheckBoxValues + " FROM customerInfo";

and then execute that string query.

drani:

In a PL/SQL Procedure I did the following using a Drop-Down LOV (List Of Values with the Multi-Select feature) and a two-dimensional Array for holding the selected values. There are Buttons for Clearing or Resetting the List and Finish-Button. When the Finish-button is clicked the "Building the SELECT-Statement Procedure", begins: Loop through the array list building the SELECT-string adding a "," between each value in the array-List; At end of the Array-List add a blank-space followed by the FROM and the WHERE clauses.

Hopes this helps.

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.