Display the rows of selected columns by using checkboxlist control

Question

I have a checkboxlist control that is populated by the column names of a table. what I want to do is use a gridview to display only the contents of the particular selected item from checkboxlist.

I have tried the following code, it returns me the same number of records in the table but the content in the grid view is the same as the selected checkboxlist item.

For example, if I select pname(project name) from tblProject(projects table) I get:

pname
pname
pname
pname
pname
pname
pname....

because I have 7 records in tblProject

I use the following code:

`select ('"+CheckBoxList1.SelectedItem.ToString()+"') from tblProject`

Please, clarify your question, make it more readable to help us, help you. Where do you use, which code? — provençal le breton
– provençal le breton, Commented Aug 1, 2013 at 13:33

gzaxx · Accepted Answer · 2013-08-01 13:34:33Z

2

Remove single quotes and bracers:

"select " + CheckBoxList1.SelectedItem.ToString() + " from tblProject"

answered Aug 1, 2013 at 13:34

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

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

Comments

user1 · Accepted Answer · 2013-08-01 13:38:04Z

0

Build your query like this:

 string query = string.empty
 query += "select ";

 if (CheckBoxList1[0].Selected)
 {
      query += "first_column, ";
 }//and so on

 query += " from tblProject";

answered Aug 1, 2013 at 13:38

user1

1,0651 gold badge8 silver badges29 bronze badges

Collectives™ on Stack Overflow

Display the rows of selected columns by using checkboxlist control

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related