So, you do an UPDATE and then do a SELECT to re-populate your DataSet with the newly updated data? I suppose that that's an ok methodology (in case there were other updates to the existing data), but we don't currently do that in our existing app. We *may* have to re-think that for the new app we're working on, but at the moment I've not thought much about it.
~~Bonnie
>>I don't see how the UPDATE has anything to do with it ... you're doing a DataAdapter.Fill() so it should be a SELECT that should be getting executed.
>
>I have always done my updates like that. How are you doing it?
>
>Once the oDataAdapter.SelectCommand = oCommand is done, it need to be processed. Isn't oDataAdapter.Fill(oDataSet) the proper way of doing it?