Passing CheckBoxList parameters to Stored Procedure

Question

I have an asp.net checkboxlist which keeps my numbers

And I have a number field in my sql server database table, which can contain the values above. So when above fields checked in my checkboxlist, I want my stored procedure to filter the table with the checked values.

what is the proper way to achieve this?

score 0 · Answer 1 · edited May 23 '17 at 11:56

0

There is a way by which you can pass the DataTable to store procedure.
Here is a link for the same
http://www.codeproject.com/Articles/412802/Sending-a-DataTable-to-a-Stored-Procedure
How to pass table value parameters to stored procedure from .net code

edited May 23 '17 at 11:56

Community

1
1

answered Jun 20 '13 at 08:38

शेखर

17,412
13
61
117

Not possible to pass DataTable in sql server 2005 I think – HOY Jun 20 '13 at 08:50
then you have to loop through you list one by one and then insert or update. – शेखर Jun 20 '13 at 09:15

Passing CheckBoxList parameters to Stored Procedure

1 Answers1