We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

slower & slower on fill

Thread ID:

Created:

Updated:

Platform:

Replies:

34471 Sep 9,2005 02:48 PM UTC Sep 14,2005 08:23 PM UTC WinForms 6
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On September 9, 2005 02:48 PM UTC

Hi, I noticed that an sqladapter.Fill gets slower and slower on each call. Do you have any suggestion on how to stop this behavior? thanks this.dataSet81.customrates.Clear(); this.gridDataBoundGrid1.DataSource = null; this.gridDataBoundGrid1.DataSource = this.dataSet81.customrates; this.gridDataBoundGrid1.Model.Rows.RemoveRange(1, this.gridDataBoundGrid1.Model.RowCount - 1); this.sqlSelectCommand4.CommandText = this.origselect + " where chargecust=1 and wono =" + this.comboBoxBase1.Text + " order by seq"; try { this.sqlDataAdapter4.Fill(this.dataSet81); // <-- slower & slower } catch {} this.gridDataBoundGrid1.Model.ColWidths.ResizeToFit(GridRangeInfo.Rows(0, 20), GridResizeToFitOptions.IncludeHeaders);

Administrator [Syncfusion]
Replied On September 9, 2005 03:30 PM UTC

You can try moving the fill between where you set DataSource = null and DataSource = this.dataSet81.customrates to see if that affects this. If you comment out the grid code, do you still see the behavior. You also might try just calling Fill on the DataTable and not the DataSet. Maybe calling DataTable.Reset woul daffect this as well.

Administrator [Syncfusion]
Replied On September 9, 2005 04:22 PM UTC

Hi, I tried all those, still fill gets slower and slower. The Reset however doesn''t work at all, the grid stays empty. It reminds me of events being re-trapped over and over without any -= where they should be. where that happens i dunno, but must be in .net somewhere not syncfusion. this is a full sqladapter with update, insert, delete sql if that makes any difference. any other suggestions? i think you should be able to duplicate this problem easily enough. thanks

Administrator [Syncfusion]
Replied On September 9, 2005 05:17 PM UTC

correction: i tried leaving the grid datasource as null now the speed isn''t affected, so maybe it is a syncfusion problem after all. thanks

Administrator [Syncfusion]
Replied On September 14, 2005 06:24 PM UTC

Hi Clay, any luck with this?

Administrator [Syncfusion]
Replied On September 14, 2005 06:46 PM UTC

What events are you subscribing to on the grid grid or DataTable. Such events may be affecting this behavior. I also supect that calling grid.Binder.SuspendBinding and grid.Binder.ResumeBinding may also take care of this problem.

Administrator [Syncfusion]
Replied On September 14, 2005 08:23 PM UTC

yes, putting suspend/resume binding fixed it. thanks alot Clay!

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;