Fastest Way to show associated records
I have associated records for a user like I have District for that user, then tehsil for that user
then ucs for that user then Villages for that user ,I am saving the User Record into Two Tables
First is user Table and second is UserAndDistrict Table
User(Id(P),Name,Email,Password,DistrictId(F))
UserAndDistrict(Id(P),USERID(F),DISTRICTIF(F),TEHSILIF(F),UCID(F),VILLAGEID(F))
So on Edit i am making a inner join on these two tables my page works for user who has just no more than 10 records but when my datareader has more then 10 row it does not show checkboxlist item checked even if there values exists into the database ,
I am using LOOP mechanism for Cascade checkboxlist item mean first my loop get the District id then check thAT DISTRICT THEN PASS THIS DISTRICT ID TO Tehsil functin and get tehsil then pass that tehsil to Village function and get villages this loops works for NO OF ROWS COMMING BY STORE PROCEDURE ,how i can make is faster by using other techniques