Currently i am doing it like that. But that still does not help performance as the event fires but does nothing. What i wanted to know is, is there any property which is ensure this event fires only when the gird is data bound, otherwise it makes no sense. Why should the event fire when i change data of a cell in my code?

Cheers,

SK

Ok i have figured out what the problem is. It is the inability of the Grid (or datasource, read dataset) to load all the child rows when datasource is set. Is there a solution to this problem? I need this functionality to expand / collpse all or selected rows. Do i need to use UltraDatasouce? If yes can i convert a dataset to an Ultradatasource? Where do i start looking for?

contactkalim said:

Ok i have figured out what the problem is. It is the inability of the Grid (or datasource, read dataset) to load all the child rows when datasource is set. Is there a solution to this problem? I need this functionality to expand / collpse all or selected rows. Do i need to use UltraDatasouce? If yes can i convert a dataset to an Ultradatasource? Where do i start looking for?

I'm not sure what you mean by this. Loading child rows can be an expensive operation, but that has nothing to do with the grid, it's the data source that determines this. A DataSet, in particular, is pretty inefficient when it retreives child rows. So if expanding rows is slowing down your application, but might want to consider using a more efficient data source. But what you use really depends on the needs of your application, so it's hard to off your any advice on that without knowing a lot more about what you are doing. 

What iam doing is that i have a dataset in which i have 2 datatables which have a parent child relationship. This is bound to the UltraGrid. Now I needed a check box and and image column at level 1 rows and disbale level 2 rows. So i was looping through all rows in the Grid to do this. This was making the grid load very slowly. Then i felt may be i should use Initialize row event. That seemed to have fixed the loading problem. But i have a feature where users can expand / collapse all or selected rows. That seemed to be taking time now. So i thought may be its the problem of the InitializeRow event. But that is not the case as per you and the forum its the datasource which is a Dataset which is slow when fetching child rows. So please suggest me a datasource which serves my purpose otherwise please tell me why should i pay licence fee for this grid. What i wanted to know is how i can use some other datasource in the present condition? I have a Dataset so definetly i should be able to convert this into some other datasource for which the Grid gives me the functionality our users want. Please advice.

contactkalim said:

What iam doing is that i have a dataset in which i have 2 datatables which have a parent child relationship. This is bound to the UltraGrid. Now I needed a check box and and image column at level 1 rows and disbale level 2 rows. So i was looping through all rows in the Grid to do this. This was making the grid load very slowly. Then i felt may be i should use Initialize row event. That seemed to have fixed the loading problem.

Okay, that makes sense.

contactkalim said:

So i thought may be its the problem of the InitializeRow event. But that is not the case as per you and the forum its the datasource which is a Dataset which is slow when fetching child rows. So please suggest me a datasource which serves my purpose otherwise please tell me why should i pay licence fee for this grid. What i wanted to know is how i can use some other datasource in the present condition? I have a Dataset so definetly i should be able to convert this into some other datasource for which the Grid gives me the functionality our users want. Please advice.

Okay. I very much doubt that the InitializeRow event has anything to do with this. As I said, the DataSet tends to be pretty inefficient when you retrieve child rows. This has nothing to do with the grid, and you would experience the same issue with any control that displays hierarchical data.

I don't know of any other data sources that retrieve data from a database, but if you want to use a data source that is more efficient, then you could use the UltraDataSource component. Of course, you would have to load all of the data into this control up front, so that would cause a performance hit. Perhaps there are other, 3rd-party data sources out there that are more efficient than the DataSet. 

I have used UltraDataSource and converted my Dataset to UltraDataSource. What i really wanted was a sample on how to convert Dataset to UltraDataSource. But i had to do it all myself. This was a bit disappointing after having paid for almost 10 developer licenses for Infragistics.

It might have saved me some time.

Hm, I guess I must have missed it when you asked how to do that. In any case, there is no automatic conversion, you simply have to loop through the rows and copy the data.