Danish Habib

Danish Habib

  • NA
  • 694
  • 233.3k

Fastest Way to show associated records

Jan 30 2015 5:12 AM
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 

Answers (1)