You are doing a select in your query, and you are expecting Update? Sorry, your question wasn't clear.

But one thing that your code snippet really says is that you want to use TableAdapterManager.UpdateAll() method to do a hierarchical update instead of calling TableAdapterManager.Update methods individually.

And note that for this to work, you need to set the HierarchicalUpdate property to true in the dataset designer.

kalpana aparnathi replied to David on 09-Jan-12 03:38 AM

hi,

it's not clear if you need this to be done in the client tier

would it not be possible to just do this in a simple sql statement or stored proc, if all the gui is doing is showing whats in the dbms