Database table design issue

Danish Habib

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikram Agrawal11y ago
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 Kumar11y ago
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 (districtid,districtname)
Tehsil (district id(F), Tehsilid,tahsilname)
UC (TEhsilID(F),ucid,ucname)
Villages (UCID(F),Viallageid,village name)

And kindly share code for better understanding of problem.
Danish Habib11y ago
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 uc,one for villages on District i have (districtid,districtname) for Tehsil i have (district id(F), Tehsilid,tahsilname) for uc i have (Districtid(F),TEhsilID(f),ucid,ucname) for Villages i have (districtid(f),TehsilID(f),UCsID(f),Viallageid,village 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 Kumar11y ago
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.