TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Danish Habib
NA
694
244.4k
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
Reply
Answers (
1
)
Difference between string class & stringbuilder class in c#
Difference between value type and reference type in c# with