Solved

Dataset Accept Changes causing crash

Posted on 2013-06-26
3
178 Views
Last Modified: 2014-02-12
Hi
I have a calculation which I run against the rows of a datatable. The code below is run if the user picks the Count Policy option.
It runs fine if there are a thousand or so rows. However, over a certain number, this step will cause the program to crash.
I'm not sure exactly where in the procedure is causing the crash, but I do know that the report will complete if the User does not select the Count Policy option.

Private Sub Count_Policy()
Dim rowRenewal As RenewalsRow

For Each rowRenewal In Me.PolicyDataSet.Renewals
   rowRenewal.PolicyCount = Me.PolicyDataSet.Renewals.Compute("Count(BrokerRef)", "PolicyRef = '" & rowRenewal.PolicyRef & "'")
Next

Me.PolicyDataSet.Renewals.AcceptChanges()

End Sub

Open in new window


I suspect that are just too many rows for the AcceptChanges to process.
Any suggestions on how I could improve this code to not cause a crash? Note that I cannot change the way that data is loaded into the dataset, so please do not give any suggestions that involve SQL.
0
Comment
Question by:jdhackett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 42

Expert Comment

by:sedgwick
ID: 39277764
what exception is being thrown?
0
 
LVL 1

Author Comment

by:jdhackett
ID: 39278027
No message appears on screen. The application just stops responding, and you have to end it from task manager.
I haven't been able to replicate the issue on my own PC, so I can't debug it from Visual Studio.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39278239
Do you know how long the user waits? It could be that the computation is still going on and app is not responding to user input so user is killing it. You can update UI to indicate the progress.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question