Data reader Reading multiple rows (please Assist)

Question

Dear I have data reader into my web application and now I want to read rows and my table containing 233 rows and based on each record (each row) i am populating checkboxlist based on these records , so my reader in while loop loops 233 times and this works locallly (mean on local database) and does not work when working live (live Database)
Any one have an idea??

Khargesh Rajput · Answer

Instead of populate checkbox in looping in datareader You can use below method http://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx

Danish Habib · Answer

it is not giving any error and i have gridview and on edit of that grid view i am showing checkboxlist items selected so after one minute wait nothing happens mean that i my data reader has 20-40 rows it works fine but if the data reader has more than 40 rows it does not show records on edit of a single entity (single record) may be due to loops i have using nested loops

Khargesh Rajput · Answer

are you getting error online or not getting record in datareader

pritaeas · Answer

What do you mean with does not work ? Is the connection string correct the table exists live and has data? Do you get an exception?