Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: (untagged)
I have hierarchical database the database structure is below I have users into my application and these users are associated with different locations and these locations are cascade in nature ....
District----->populates------>Tehsils

Tehsils------>populates----->UC

UC------->populates------>villages

For that purpose I have created 5 tables

User(userid(P),UserName)

DistrictAssociation(districtID(P),DistrictName,UserID(F))

TehsilAssociation(TehsilID(P),TehsilName,DistrictID(F),UserID(F))

UCAssociation(UCID(P),UCNAME,UserID(F),TehsilID(F))

VillageAssociation(VillageID(P),VIllageName,UCID(F),UserID(F))

To save all these Id I am Using Four Table Value Parameter for all Association Table and simple Stored Procedure for basic UserID And Name .

On Each Table Value paramter as u know from the above struct If i am taking the UCAssociation Table as an example then for every uc i have to need its tehsil so i made a function passing uc id and getting tehsil id , so the whole process takes unexpected time to save and the first three table value parameter work but the last villageAssocaition does not work it work fine localy but on live it become in loop of wait and never end and when i check the db it show the first three table value but not the last one on live environment but locally all work fine .
Posted
Updated 14-Apr-15 21:39pm
v2
Comments
ZurdoDev 15-Apr-15 8:48am    
This does not make any sense at all.
Malikdanish 15-Apr-15 8:54am    
simply i am using four table value paramter for insertion and process get too slow to insert the record

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900