Database table design issue

Question

I have User into my application and each user has assigned (District,Tehsil,UC,Villages) these are cascade in nature means
1-District contains tehsils
2-Tehsil contains ucs
3-Ucs contains villages

Now i have place checkboxes and they are populating right based on selected , but when i de select or select another districts the previous checkbox result set lost due to post back.

My second question please suggest me a database structure for that

Vikram Agrawal · Answer

Hi Danish Maintain your table as @Jitendra explained and in user table put villageId column. and one more thing i want to suggest you as you are using server side codes for populating the values based on district so make this in client side then performance of your web page will be increase and also you will not get these problem which are coming due to post backs. Thanks.

Jitendra Kumar · Answer

Hello Danish First one problem in database that is you maintain a primary foreign relationship in tables so why use district key again and again in the tables. Tables likes :- District (districtiddistrictname) Tehsil (district id(F) Tehsilidtahsilname) UC (TEhsilID(F)uciducname) Villages (UCID(F)Viallageidvillage name) And kindly share code for better understanding of problem.

Danish Habib · Answer

Dear Kumar Thanks for your Response. First I have a question about database table creation I have user and each user have district tehsils uc and village these four values are cascade in nature mean on district selection the tehsil pops up on tehsil selction the ucs pops up and on uc selection the villages pop up DISTRICT---->Tehsils----->UCS----->villages First tell me the best database solution it is many to many relationship. Secondly I am telling you the design which i have implement I have created four tables one for district one for tahsil one for ucone for villages on District i have (districtiddistrictname) for Tehsil i have (district id(F) Tehsilidtahsilname) for uc i have (Districtid(F)TEhsilID(f)uciducname) for Villages i have (districtid(f)TehsilID(f)UCsID(f)Viallageidvillage name) I have saved data into the database and i have created a method whcih get the selected checkbox district and pass that and fetch the tehsil of taht district the problem is that when post back it loses its value

Jitendra Kumar · Answer

Hello Kindly share code file for better understanding problem. First if you select a district then how find tahsil uc village of user. bcz acc to you district and tahsil have one to many relationship.