Why does Dataset.table(n).clear take so long?

Hot Topic

Win32Exception while creating a form
can anyone help me to getrid of this error....
ArrayList problem
hi
ImageList with EnableVisualStyles with Framework 1.1
how can use a dynamic diagram to show the data transfer?
Application settings
Format phone number
Problem With CheckedListBox
BackColor of MDI Parent Form

Windows Forms

ClickOnce Installs fail, ADODB 7.0.3300 required?!
Webbrowser controls doesn't work on Windows XP SP2
How Can I Disable the VisualStyles From One Control ??
Serialize a forms region?
Windows Forms 2.0...is this right for me?
Serialization of custom colors (and other types)
Automatic toolbox item service ignores ToolboxItem attribute
ListBox is really slow on adding about 64000 items
Email from app
attempt to center a picturebox

Why does Dataset.table(n).clear take so long?

I need to refresh my dataset when external changes have been made.

To do this I first clear the datatable from the datasetusing the following code:

dsDataSet.Tables("Customer").Clear

This sinlge line of code can take between 1 and two minutes to run even though the table has only 1354 rows in it..............WHY

Can anyone shed any light on this or advise me of another way to do this


Answer this question

Why does Dataset.table(n).clear take so long?

  • re10

    Cheers Bloke, you really are a star !!

    I'd never even come across the merge method before - what a simple and effective idea !!

  • Russell Lanning

    Thats a strange one.  When updating data like that I use the DataSet.Merge method.  It stops DataGrids, ListBoxes etc from flickering.
  • Why does Dataset.table(n).clear take so long?
Answer this question