CheckBox adding Parameter to Gridview

Question

I have a CheckBoxList that is showing all A table C column.

SELECT  DISTINCT C
FROM A
ORDER BY C

My A table has two columns.

B-->Primary Key

C--> Every C has a unique B.

I have an SQL like this for my Gridview Source;

Select <...............>
From <..................>
Where <.................>
AND A.B IN 
(Select A.B 
From A 
Where A.C IN ALL CheckBoxList.SelectedItem.Value)

Something like that. My SQL syntax isn't very good. I hope you can tell what I want..

What I REALLY want is, when I click a button, Gridview should be populated according to the SQL , BUT filtered by what is selected in CheckBoxList.

Is there any way to add a parameter in the SQL IN clause? How can I do that?

Best Regards,

Soner

Community · Accepted Answer · 2017-05-23 10:33:10Z

1

When I encountered an issue like this, I took a data table (precomputed, equivalent to all the boxes being checked) and just used a LINQ query (I asked about that query here). Basically, in the context of your question, I just used a standard LINQ query, building a filter by ORing all the checkboxes to form a filter. I created the filter itself using PredicateBuilder. I only needed the 26 lines of code under "Predicate Builder Source Code."

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Mar 22, 2011 at 17:29

Brian

25.9k18 gold badges87 silver badges179 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:02:54Z

1

Different Solution is discussed in the following URL : Parameterize an SQL IN clause Have a look at it.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Mar 22, 2011 at 14:52

varadarajan

5141 gold badge3 silver badges9 bronze badges

Collectives™ on Stack Overflow

CheckBox adding Parameter to Gridview

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related