Need help in Datagrid

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I am developing a windows application. This contains a Data grid which will
populate data from a data table in a Dataset.
The application will do some calculation and store the result in the Data
table. After the calculation, the result stored in the data table will
display in the data grid.

When number of rows need to populate in the data table after calculation is
around 16000, application will take around 30 seconds to do the whole work.
Because of this Data grid population from data table will also take 30
seconds or more. During these 30+ seconds, form will be blank and user cannot
do any activity.

I like to know, Is there any way to display the calculated rows part by part
to the data grid from data table. (Like Buffer.Flush in Asp.net, to display
part of the out put to the user). If I am able to display 1000 rows after
calculation from data table to the data grid, the user no need to wait for
whole calculation to be completed for the out put

Give me some reply on this.
Thanks in Advance.
Umesh
 
Umesh,

I once have created a routine to do a partial fill from a datatable. The
problem is that it slows down the total thoughput time enormous, because I
had to use the where clause and the top in the select.

However do you use the expression columns, because maybe that can speed up
your calculation time.

I hope this gives an idea.
(When you want a link for those expression columns than reply)

Cor
 
Back
Top