Mixing
How do I keep a VS Lightswitch Combo box from timing out?
In a Lightswitch Desktop Client (C#) application I have a List/Detail screen where I add participants to a class roster. This application has been in use for more than a year and has worked fine but now the "Participants" table has grown to more than 2500 records. The List/Detail screen for "Classes" has a sub form for "RosterAttendences". In the RosterAttendences sub form there is a combo box/pulldown to list all of the participants in the Participants table so that the data entry person can add records for individuals to the roster for that class. In the test instance on VS it works fine but with live application/data it times out. First the spinning blue circle will appear as soon the down arrow is selected and eventually (more than a minute) it will stop and be replaced with a red X. All of the other combo boxes in the application function properly and the current work around is to add the classes in the participant's profile which also is working properly. Is there a way to optimize the combo box so that it does not time out?
c# visual-studio visual-studio-lightswitch
asked Nov 19 '18 at 19:52
MarkMark
931115
add a comment |
In a Lightswitch Desktop Client (C#) application I have a List/Detail screen where I add participants to a class roster. This application has been in use for more than a year and has worked fine but now the "Participants" table has grown to more than 2500 records. The List/Detail screen for "Classes" has a sub form for "RosterAttendences". In the RosterAttendences sub form there is a combo box/pulldown to list all of the participants in the Participants table so that the data entry person can add records for individuals to the roster for that class. In the test instance on VS it works fine but with live application/data it times out. First the spinning blue circle will appear as soon the down arrow is selected and eventually (more than a minute) it will stop and be replaced with a red X. All of the other combo boxes in the application function properly and the current work around is to add the classes in the participant's profile which also is working properly. Is there a way to optimize the combo box so that it does not time out?
c# visual-studio visual-studio-lightswitch
asked Nov 19 '18 at 19:52
MarkMark
931115
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30
add a comment |
In a Lightswitch Desktop Client (C#) application I have a List/Detail screen where I add participants to a class roster. This application has been in use for more than a year and has worked fine but now the "Participants" table has grown to more than 2500 records. The List/Detail screen for "Classes" has a sub form for "RosterAttendences". In the RosterAttendences sub form there is a combo box/pulldown to list all of the participants in the Participants table so that the data entry person can add records for individuals to the roster for that class. In the test instance on VS it works fine but with live application/data it times out. First the spinning blue circle will appear as soon the down arrow is selected and eventually (more than a minute) it will stop and be replaced with a red X. All of the other combo boxes in the application function properly and the current work around is to add the classes in the participant's profile which also is working properly. Is there a way to optimize the combo box so that it does not time out?
c# visual-studio visual-studio-lightswitch
asked Nov 19 '18 at 19:52
MarkMark
931115
In a Lightswitch Desktop Client (C#) application I have a List/Detail screen where I add participants to a class roster. This application has been in use for more than a year and has worked fine but now the "Participants" table has grown to more than 2500 records. The List/Detail screen for "Classes" has a sub form for "RosterAttendences". In the RosterAttendences sub form there is a combo box/pulldown to list all of the participants in the Participants table so that the data entry person can add records for individuals to the roster for that class. In the test instance on VS it works fine but with live application/data it times out. First the spinning blue circle will appear as soon the down arrow is selected and eventually (more than a minute) it will stop and be replaced with a red X. All of the other combo boxes in the application function properly and the current work around is to add the classes in the participant's profile which also is working properly. Is there a way to optimize the combo box so that it does not time out?
c# visual-studio visual-studio-lightswitch
c# visual-studio visual-studio-lightswitch
asked Nov 19 '18 at 19:52
MarkMark
931115
asked Nov 19 '18 at 19:52
MarkMark
931115
edited Nov 27 '18 at 22:35
Mark
asked Nov 19 '18 at 19:52
MarkMark
931115
asked Nov 19 '18 at 19:52
MarkMark
931115
asked Nov 19 '18 at 19:52
MarkMark
931115
931115
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30
add a comment |
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30
add a comment |
2 Answers
2
active
oldest
votes
Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.
https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch
answered Nov 30 '18 at 19:48
MarkMark
931115
add a comment |
If time is not an issue you might increase ClientTimeout
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381705%2fhow-do-i-keep-a-vs-lightswitch-combo-box-from-timing-out%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.
https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch
answered Nov 30 '18 at 19:48
MarkMark
931115
add a comment |
Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.
https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch
answered Nov 30 '18 at 19:48
MarkMark
931115
add a comment |
Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.
https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch
answered Nov 30 '18 at 19:48
MarkMark
931115
Change the field from Auto Complete to Modal Window Picker when more than say 100 records. You get searching, sorting and paging but there are usability concerns as it will take more mouse clicks but it's the only way to handle large amounts of data.
https://social.technet.microsoft.com/Forums/en-US/88001cd8-539c-47cd-8599-f1703d2a1cd9/how-do-i-optimize-a-combo-box-in-a-desktop-client-app-created-with-lightswitch-c?forum=lightswitch
answered Nov 30 '18 at 19:48
MarkMark
931115
answered Nov 30 '18 at 19:48
MarkMark
931115
answered Nov 30 '18 at 19:48
MarkMark
931115
answered Nov 30 '18 at 19:48
MarkMark
931115
931115
add a comment |
add a comment |
If time is not an issue you might increase ClientTimeout
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
add a comment |
If time is not an issue you might increase ClientTimeout
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
add a comment |
If time is not an issue you might increase ClientTimeout
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
If time is not an issue you might increase ClientTimeout
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
answered Dec 5 '18 at 11:22
Konstantin SalavatovKonstantin Salavatov
2,97921819
2,97921819
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
add a comment |
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
1
1
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
The number of records in the database has increased a lot and the solution outlined below increases the number of clicks to get the record saved but it is much faster. Before it completely failed data entry people were waiting 5 seconds or more for the dropdown to populate. However, thank you for your help.
– Mark
Dec 5 '18 at 15:06
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
yes, all depends on actual requirements
– Konstantin Salavatov
Dec 7 '18 at 8:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381705%2fhow-do-i-keep-a-vs-lightswitch-combo-box-from-timing-out%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Unrelated note about the tag visual-studio. If you read the description, it says DO NOT use this tag on questions regarding code which merely happened to be written in Visual Studio., so it should not be used in this question. Consider adding a C# tag.
– Richardissimo
Nov 21 '18 at 21:30
Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself.
– Richardissimo
Nov 21 '18 at 21:31
The desired behavior is to not have it time out and the solution, even though the underlying code is c#, will be executed within Lightswitch. As Lightswitch is being retired by Lightswitch and not included in newer versions of VS chances that I get assistance here are slim. I know there are people out there who can help. Thank you for your comments.
– Mark
Nov 27 '18 at 22:40
Adding the C# tag: good; there are lightswitch tags as well which might help. "in the question itself" means that the information needs to be put it in the question itself, not a comment. And the "shortest code necessary to reproduce" is still unsatisfied - we need a Minimal, Complete, and Verifiable example. As it stands, I suspect this question will remain unanswered.
– Richardissimo
Nov 28 '18 at 6:30