Georgi,

I read the batch update info, I'm not seeing how batch updating will help. I want to update the grid via some code and not via having the user type in something. I'm not seeing a way to change the value in a cell via code after the button click, is there a way?

Let me tell you more about my problem...

In the second band of a WebHierarchicalDataGrid I have a column with a button, when I click the button I want to do a calculation and change the value in another column of the same row with the result of my calculation, and then I want the changed value to show up in the grid and the database.

I get the impression that the best way to do this is to programmatically change the value on the client side via some javascript, correct?

This would allow the grid and database to both reflect the change??

Is this the best approach for my situation?

Is there another way to solve this problem?

So, if this is correct....

I've wired up a button click event and I can get the gridView on the client side using javascript.

However, now I can't get the cell or row I just clicked on. The .get_ActiveCell() is always null.

How can I get the cell / row I just clicked the button in?

Thanks,

Brian.

Georgi,

I tried your suggestion. After executing the SQL update I call this code in the button click event.

 WebHierarchicalDataGrid1.GridView.ClearDataSource();

  WebHierarchicalDataGrid1.DataSourceID = "WebHierarchicalDataSource1";     

However, this causes the second band I'm on to collapse and the user loses where they were in the hierarchy.

The closest thing I've been able to do is place the  WebHierarchicalDataGrid into a UpdatePanel, then after the SQL update I set the text in the row to what I know the SQL update would do. Plus, I disable the button. But, this has some undesired side effects when the grid resorts.

I'm thinking that a better solution would be to programmatically set the values in the row instead of via the SQL update command. Would this be a better solution? If so, how can I set the value for the row in the click event?

Thanks,

Brian.