intercept data adapter fill method events
Posted on 2006-04-21
Is there anyway to intercept the fill method events when filling a dataset?
I wish to analyze data as it is going into a dataset's datatable (or tables) to process the information.
Currently, the only way I know how to do this is to parse the datatables again to look for values and modify (e.g. null checking) them OR by using a SQLdatareader and looping as each row is being filled.
The dataset, while convenient, is a bit too slow when having to re-loop through the records afterwards (ie going through it twice is a waste of time) to make changes that could have been made while the data is loading.
Is this possible? (in .Net 1.1)