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`

```