retrieve data in datalist from DB based on Checkboxlist Item

Question

hello, My Question is how to retrieve data from database in datalist based on checkboxlist values. like filters use in ecommerce. for ex. i have a checkbox list it has priorities for questions. hard , easy , important. when user check on hard all hard questions show in datalist. when check hard and easy both, then both priority question show in datalist, then if he/she uncheck one item . then remaining checked priority questions still show in datalist. its urgent.?

Jignesh Kumar · Answer

Hi Pavan, Please find below link for same. https://www.aspforums.net/Threads/807805/Get-details-of-DataList-Item-inside-CheckBox-CheckChanged-event-in-ASPNet/

Sreekanth Reddy · Answer

bool item1check = false; bool item2check = false; bool item3check = false; bool item4check = false; if(chkbox1[0].checked == true) item1check = true; if(chkbox1[1].checked == true) item2check = true; if(chkbox1[2].checked == true) item3check = true; if(chkbox1[3].checked == true) item4check = true; sqlconnection... sqlcommand.... // Mention your Dynamic Stored Procedure sqldataadapter... cmd.parameters.AddwithValue("@item1",item1check) cmd.parameters.AddwithValue("@item2",item2check) cmd.parameters.AddwithValue("@item3",item3check) cmd.parameters.AddwithValue("@item4",item4check) ..... ...

Pankaj Pawar · Answer

There is any developer. Who can answer my question.

Pankaj Pawar · Answer

Could you provide a simple basic exmaple with code.

Sreekanth Reddy · Answer

For this type of requirements, You need t write "Dynamic Stored Procedures". For knowing more about dynamic stored procedures follow the below link : https://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure Hope you understood. If not, Come up with your query. Mark as answer if it helps. Tank you.