dcsimg

Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 2.07 seconds.

  1. Re: How to cancel long running TableAdapter Fill query

    @Funky - no, it wasn't the length that scared me. Your scare tactic worked, saying "cancel". (LOL, just kidding).
    OK, I'm happy with how it's working and unless szlamany jumps in and asks what...
  2. Re: How to cancel long running TableAdapter Fill query

    Just a select...no temp tables. That's why I'm not really all that concerned with the app cancelling it.
  3. Re: How to cancel long running TableAdapter Fill query

    I am re-reading and digesting your replies some more ... so you are saying perhaps it takes more DB resources to kill the query than to just let it finish. If I implemented the code behind the...
  4. Re: How to cancel long running TableAdapter Fill query

    Thanks for all the thought you put into those replies!

    This started with an email from my boss: Is it possible to add a button to cancel a query if it runs too long?

    So yes that is something...
  5. Re: How to cancel long running TableAdapter Fill query

    Gary - Do you know of a problem with CancelSelect in that link in post #8?

    I wrote this, it's working, but of course the reason why I didn't want to just grab code willy-nilly off the internet is...
  6. Re: How to cancel long running TableAdapter Fill query

    Yes I have implemented everything successfully as far as running the query in a background thread goes. What I need now is when the Cancel button gets clicked (another name for the Search button...
  7. Re: How to cancel long running TableAdapter Fill query

    Thanks. Yes, I am having no problem with your 2nd sentence. Regarding your first sentence, we have no DBA. The closest thing to a DBA is yours truly and I am not screaming, LOL.
    So what I'd like...
  8. Re: How to cancel long running TableAdapter Fill query

    Oh, and here's part 2 of my question. Even if the user can't cancel the query, the next best thing is that it runs in the background and they can continue with other work while they wait. If they...
  9. Re: How to cancel long running TableAdapter Fill query

    Also, the query that the Fill runs is a stored procedure, if that is relevant...

    using (dtCustomers = new dsCustomerList.xsp_GetAllCustomersMatchingCriteriaDataTable())
    ...
  10. [RESOLVED] How to cancel long running TableAdapter Fill query

    Happy New Year everyone!

    I am running a database query that I want to give the user the ability to cancel. It's a search function and the user can enter all kinds of criteria related to our...
  11. Re: Stored procedure, optional parameters

    Since what I really wanted to do was pass in a list of the emp departments and do an "IN", I solved it : this way
  12. Re: Stored procedure, optional parameters

    Wait, sorry, I have a question now that I am looking more closely. The user doesn't have to pick an employee's team. They might only want to pick a certificationID and not a specific team which by...
  13. Re: Stored procedure, optional parameters

    Yeah, I hear you about 5 and 6, LOL!
    I tried AND's, OR's, nothing made a difference. I will try your suggestion, thanks!
  14. [RESOLVED] Stored procedure, optional parameters

    I write stored procedures all the time that take optional parameters so I don't know why I can't get this one to return the results I want.
    Simply put, we have employee records with a field saying...
  15. Re: Where would I start looking for a memory leak?

    And please allow me to throw out this question which I hope isn't "stupid" - my application is click once so everyone downloads it to their own PC. Can GC be running differently on different users...
  16. Re: Where would I start looking for a memory leak?

    I've been reading something over and over to see between the lines what I am missing. Here is a summary of what's happened in the past few days. The vendor looked into the possibility of their...
  17. Re: Where would I start looking for a memory leak?

    So...there was a problem with the DevExpress Dictionary and they had updates in releases 15.2.15, 16.1.8, 16.2.3.
    Then apparently the problem was re-introduced and they had updates 17.2.10, 18.1.6,...
  18. Re: Where would I start looking for a memory leak?

    There is perhaps a problem with the DevExpress dictionary!

    Am looking into that now!
  19. Re: Where would I start looking for a memory leak?

    It could also be this:


    private void InitializeComponentSpellCheck()
    {
    spellChecker1 = new SpellChecker();
    spellChecker2 = new SpellChecker();
    ...
  20. Re: Where would I start looking for a memory leak?

    I am posting my code. In parallel, I will remove the dictionary from my local copy of the code and open/close the form and watch the memory usage in Task Manager.


    public class...
  21. Re: Where would I start looking for a memory leak?

    Here is the exception of the dump I referred to last post:
    frmJobEntry3 is the case form.

    System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
    at...
  22. Re: Where would I start looking for a memory leak?

    I have a dump of the exception - it just happened to somebody. Is there anything useful in there?
    And thanks, OptionBase1. I am thinking how to cut it down and start cutting parts out to isolate...
  23. Re: Where would I start looking for a memory leak?

    [Deleting - somehow posted the same things as 12:40]
  24. Re: Where would I start looking for a memory leak?

    So the exception hasn't occurred (that they're telling me about) but someone was looking at Task Manager while running my application and noticed every time the "case" form was opened and closed,...
  25. Re: Where would I start looking for a memory leak?

    I will have the users capture the detailed info and send it to me so I can start keeping track and looking for a pattern. It doesn't happen regularly or frequently, so I may not post back for some...
  26. Where would I start looking for a memory leak?

    There are 50 or so users of my application in-house at our company. They start it in the morning and run it all day long, 8:00 a.m. - 4:30 p.m. If my application is crashing for a few users...
  27. Re: [RESOLVED] How far will you go to avoid a double-negative?

    Yup, it has a small issue! LOL. Small I can deal with.
  28. Re: How far will you go to avoid a double-negative?

    We are using a dropdownlist. The choices are "YES (Customer has PM)" and "NO (Customer does not have PM)". This has worked for us in the past. On occasion, my boss has asked for it to be presented...
  29. Re: How far will you go to avoid a double-negative?

    Moribund? That is so sad. I think I will cry.


    "We"? As in people at work??? But yes, I see the confusion!

    Anyway, I think passel made a good point when s/he spoke of a deviation. But...
  30. [RESOLVED] How far will you go to avoid a double-negative?

    I hate double negatives because I agree with this.

    So I am fighting my boss who just asked me to create a new checkbox called "No PM". This would indicate that a customer doesn't have...
  31. Re: Can I write a view with IIF in it?

    Hunh. How I ever didn't see that on my own, I can't even begin to explain. Many thanks for being my eyes today!
  32. [RESOLVED] Can I write a view with IIF in it?

    I guess a long time ago, before IIF was invented (or available to us), my fellow developer wrote his own iif function that went like this:


    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    --...
  33. Replies
    3
    Views
    529

    Re: Do you write joins like this?

    Interesting. Thanks. I will take a look at it some more on Monday. The great outdoors is calling me right now, LOL.
  34. Replies
    3
    Views
    529

    Do you write joins like this?

    An easy question for you on a Saturday (that is actually sunny and warm over here in New England!)

    I am working with someone else's query, and is this some kind of a shorthand to list a couple...
  35. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    To TysonLPrice, I apologize. I didn't even see your post. However, I did not want to change the sproc. I didn't believe that was the way to go, since the full dataset was fine yet the filtered...
  36. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I figured out what I could do. (The hard part was explaining to the company VP, who was being my sounding board, why this worked and the other way didn't!)

    Since the code liked the full datatable...
  37. Re: Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I know what you are saying, but I am not sure it will help. Here is my scenario right now. I chose PA with an empID of 80. So right here, I am on the bolded line exeptioning

    ...
  38. [RESOLVED] Don't (Throw Exception) on NullValue - your help is URGENTLY requested!

    I'm having this problem but I don't understand why.

    I am running a stored procedure from my C# code called xsp_ProjectList. It gets a list of projects our employees are working on. Then there...
  39. Re: query to get a row with MAX date and one other column

    Yes, that is exactly what I was missing! Thanks again!
  40. Re: query to get a row with MAX date and one other column

    Thank you! I totally switched gears and don't want to end the week in a bad mood so I'll try this when I'm done!
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width