Form Loading with GDBG Column Creation Time

[Umesh Kumar]

Hi,

In a certain application,whenever there is a change in the combo box index, the relevant grid columns will be created after clearing the contents of the earlier form.

Here, when the application changes from one form to another by the change of the combo box event,it is taking alot of time(roughly >15sec) in creating the columns and for the binding and for loading the relevant combo boxes in the grid.

How to speed up the form load, when the application switches from one form to another form.

The application is something like this, with single form single grid, the columns will be created and cleared as per the combo box (independent control).

Even for the first time it is taking more time to load the data into the controls.

Any Guidelines how to overcome this problem.

Thanks & Regards,
logicengineer

[Administrator]

So, are you dynamically building a new DataSource for the grid, or are you modifying the same DataSource.

If you are modifying the same DataSource, before doing your work, you might try calling grid.BeginUpdate() and grid.Binder.SuspendBinding(). Afterwards, you can call grid.Binder.ResumeBinding() and grid.EndUpdate().

Maybe this will speed things up.

[Umesh Kumar]

Hi Clay,

Thanks Clay for the suggestions.

It is working fine for the first time when the form is loading.
but when the application is switching from one grid columns combinations to another grid columns, it is taking some time.
Note:Columns are created dynamically.

here switching from one to another, i am clearing the columns, making the datasource and datamembers to null.is it correct or i have to follow some other sequence in clearing the grid columns and then again creating the columns.
Note:Only single instance of the grid is used for creating different grids for different values,is it creating the problem.

pls. throw some light on this aspect and also suggest,how solve this problem.
How to performance and speed in creating the columns.

Thanks & Regards,
logicengineer.

>So, are you dynamically building a new DataSource for the grid, or are you modifying the same DataSource.
>
>If you are modifying the same DataSource, before doing your work, you might try calling grid.BeginUpdate() and grid.Binder.SuspendBinding(). Afterwards, you can call grid.Binder.ResumeBinding() and grid.EndUpdate().
>
>Maybe this will speed things up.

[Administrator]

Here is a sample. It swaps out the datasource everytime you click the button. It uses the same grid, but creates a new random DataTable with each click. It does not seem to be that slow to me. Does it to you? What are you doing that is different? SwapDataSources_6095.zip