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
245.8k
Challanging Exercise Checkboxlist item
Feb 2 2015 7:35 AM
I have a page where i have user with some information like name,email,District(from where he belongs),Tahsil,UC,Villages
The District,Tehsil,UC,Villages are cascade in nature means that the district have tehsils in it and the tehsils have ucs in it and the ucs have villages in it , When i select the district checkboxlist item the tehsils will populates (associated with that district) and when i select the Tehsils the UCs will populates and when i select the UCs the villages will populates
I am saving these values into the table Having the userid as foreign key
Like that
District(districtId(P),Districtname,Userid(f))
Tehsils(TehsilID(P),TEhsilNAme,Userid(F))
UC(UCID(P),UCNAME,Userid(F))
Villages(VillageId(P),VillageName,Userid(F))
I am saving these values into their separate table But When i am going to gridview edit I get many many rows when i am using join all these table to get the value from all District tehsil ucs and villages
AS my Records are associate so my data reader gets 144 rows If then it fetches rows one by one it first iteration it gets DistrictId and then if in first row which data reader comes in it matches that value from the checkboxlist using for each loop and it this comes from datareader it makes this selected and pass this value to another funcation whcih populates teh Tehsils based on this District id and this process goes narrow down to Villages so due to many rows and looping process my form never goes into edit mode and it end without showing result in edit mode please need assistance
Reply
Answers (
0
)
inserting data into database
what tables should I create