Click here to Skip to main content
15,886,919 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Video Calling Pin
ZurdoDev9-Feb-15 4:58
professionalZurdoDev9-Feb-15 4:58 
QuestionUsing a linq in aspx Pin
Member 110844697-Feb-15 9:59
Member 110844697-Feb-15 9:59 
AnswerRe: Using a linq in aspx Pin
Richard Andrew x647-Feb-15 10:55
professionalRichard Andrew x647-Feb-15 10:55 
AnswerRe: Using a linq in aspx Pin
Richard MacCutchan7-Feb-15 22:13
mveRichard MacCutchan7-Feb-15 22:13 
AnswerRe: Using a linq in aspx Pin
ZurdoDev9-Feb-15 5:00
professionalZurdoDev9-Feb-15 5:00 
QuestionHow to export data from textbox and RichTextbox from Asp.net to Msword Templete Form? Pin
Member 85878306-Feb-15 20:37
Member 85878306-Feb-15 20:37 
QuestionRe: How to export data from textbox and RichTextbox from Asp.net to Msword Templete Form? Pin
ZurdoDev9-Feb-15 5:00
professionalZurdoDev9-Feb-15 5:00 
QuestionDatabase Query Pin
Malikdanish5-Feb-15 20:18
professionalMalikdanish5-Feb-15 20:18 
Dear Sir, I am Danish Habib and i get struck with an issue and i have placed my question in many forums but no one still replied to me which is consider as best solution ,The problem statement is below
I have a web application in which i have users and user have the following information (userid,name,email,Passowrd,SecurityQuestion,SecurityAnswer,District,Tehsil,UC,Villages)
So the business rules are as follows
1-One user can have one or more districts
2-One user can have no or many tehsils.
3-One user have have no or many ucs.
4-One user can have no or many villages
these are cascade in nature like that
District------>populates------->Tehsisl
Tehsils-------->Populates ------->UCs
UCs-------------->populates------Villages

So i have made four tables one for basic infromation of user like (userid(P),name,email,password,securityquestion,securityanswer)
4 more tables are DistrictVSUsers(Userid(F),DistrictID(P),DistrictName)
TehsilsVsUser(Userid(F),Tehsil(ID),TehsilName,DIstrictID(F))
UCsVsUser(Userid(F),UCID,UCNAME,TEHSILID(F))
VillageVsUSers(USerid(F),VillageID,Villagename,UCID(F))

These are five table nor four ...
These table are for saving purposes for showing the cascaded records i have used checkboxlist on selection of district checkboxlist the tehsil checkboxlist will populats and on selection of tehsil checkxboxlist the uc checkboxlist populats and on selection of uc checkboxlist the villages checkboxlist item populates ...so this working fine ..
Now For saving the data I am using the loop first loop goes for district and save all the district then the next loop for tehsil and then the next for UC and then the next for Villages .................

So I have assigned one user with 71 villages and now when on edit i want to show the check box checked whose values are present into the database i am getting 71 rows using data reader
"SELECT U.UserId,U.[Address],U.City,u.Country,UT.TehsilId,UC.UCID ,UC.UCName,UV.VillageId ,UV.VillageName ,UT.TehsilName,U.DistrictId,UD.DistrictName ,UD.DistrictId ,UD.UserId,U.FullName,U.IPAddress,U.IsActive,U.IsAdmin,U.IsPasswordReset,U.IsReportable,U.IsVisible,U.CreateDate ,U.Mobile,U.Password,U.ReporintPerson,U.SecurityAnswer,U.SecurityQuestion ,U.UserId,U.Email,U.UserTypes FROM Users U
INNER JOIN UserDistricts UD ON UD.UserId=U.UserId AND UD.DistrictId=U.DistrictId
INNER JOIN UserTehsils UT ON UT.UserID=U.UserId AND UT.DistrictId=UD.DistrictId
INNER JOIN UserUcs UC ON UC.UserID=U.UserId AND UC.TehsilId=UT.TehsilId
INNER JOIN UserVillages UV ON UV.UserId=U.UserId AND UV.UcID=UC.UCID
WHERE U.UserId =26
"
Now i loop from the first row and get the district id which is comming then pass that district id to a method which find all tehsils associated with that district and then select the tehsil whose value comming with datareader first row and pass that tehsil to a mthod which find all ucs assocaited with that and then select the selected and then pass the Uc id to a method to find associated villages and then checked if the first row having that value this all process is done for all rows if i have 70 rows and 70 time this process goes and makes the application very slow please assist me and give me your email to show you the code
AnswerRe: Database Query Pin
Erik Funkenbusch7-Feb-15 15:21
Erik Funkenbusch7-Feb-15 15:21 
SuggestionRe: Database Query Pin
ZurdoDev9-Feb-15 5:03
professionalZurdoDev9-Feb-15 5:03 
GeneralRe: Database Query Pin
KiranKumar Roy15-Feb-15 23:40
KiranKumar Roy15-Feb-15 23:40 
QuestionReplace text in web page at run time Pin
maxRazar4-Feb-15 22:57
maxRazar4-Feb-15 22:57 
AnswerRe: Replace text in web page at run time Pin
jkirkerx6-Feb-15 10:19
professionaljkirkerx6-Feb-15 10:19 
QuestionNot able to update global.asax file in production environment Pin
syedkhaleel4-Feb-15 18:08
syedkhaleel4-Feb-15 18:08 
AnswerRe: Not able to update global.asax file in production environment Pin
Erik Funkenbusch7-Feb-15 15:26
Erik Funkenbusch7-Feb-15 15:26 
GeneralRe: Not able to update global.asax file in production environment Pin
syedkhaleel8-Feb-15 21:29
syedkhaleel8-Feb-15 21:29 
QuestionVariables gone during grid insert command Pin
byka4-Feb-15 2:54
byka4-Feb-15 2:54 
AnswerRe: Variables gone during grid insert command Pin
Richard MacCutchan4-Feb-15 3:03
mveRichard MacCutchan4-Feb-15 3:03 
GeneralRe: Variables gone during grid insert command Pin
byka4-Feb-15 3:15
byka4-Feb-15 3:15 
GeneralRe: Variables gone during grid insert command Pin
Richard MacCutchan4-Feb-15 3:33
mveRichard MacCutchan4-Feb-15 3:33 
GeneralRe: Variables gone during grid insert command Pin
byka4-Feb-15 3:42
byka4-Feb-15 3:42 
QuestionRe: Variables gone during grid insert command Pin
Richard MacCutchan4-Feb-15 3:52
mveRichard MacCutchan4-Feb-15 3:52 
AnswerRe: Variables gone during grid insert command Pin
byka4-Feb-15 4:15
byka4-Feb-15 4:15 
GeneralRe: Variables gone during grid insert command Pin
Richard MacCutchan4-Feb-15 4:34
mveRichard MacCutchan4-Feb-15 4:34 
GeneralRe: Variables gone during grid insert command Pin
Richard Deeming4-Feb-15 5:41
mveRichard Deeming4-Feb-15 5:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.