Results 1 to 4 of 4

Thread: vb.net and store proc process

  1. Oct 21st, 2005, 02:47 AM #1
    fasttrack
    fasttrack is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    vb.net and store proc process

    Hi,

    my vb.net app start a store procedure. It takes long time to be completed.
    So my idea is to monitor the process and advise when it is finished or if it fails.

    How can I reach this goal?
    thank

    Reply With Quote Reply With Quote
  2. Oct 21st, 2005, 04:04 AM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: vb.net and store proc process

    It finishes when the method call returns. Apart from that you have no way of determining where it's up to. I suggest that you just set the Cursor to WaitCursor, as you should always do before a potentially lengthy operation, so the user knows something is happening. You may also want to execute the SP in a seperate thread if you want your UI to remain responsive.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Oct 21st, 2005, 04:34 AM #3
    fasttrack
    fasttrack is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Posts
    99

    Re: vb.net and store proc process

    the store proc run with a thread to have UI free.....

    I'll follow your suggestion......
    Reply With Quote Reply With Quote
  4. Oct 21st, 2005, 06:13 PM #4
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: vb.net and store proc process

    It will be interesting to see what ADO.NET 2.0 looks like. I read an article describing how to perform asynchronous data access in .NET 2.0, but I have been unable to find the methods it describes, so I think that they've been removed in beta 2. Maybe they'll come back for the final release, although I'd guess probably not.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width