Hi

I am successfully filling my DataSet with data using an adaptor. Prior to 
calling Fill(), I regsiter handler for the ColumnChanging event of each 
DataTable in my DataSet because I want to do field level validation of each 
data item.

Unfortunately, my event handler is NOT getting called! Does this mean that 
DataTable events do not fire during a Fill() and that they only fire AFTER a 
DataTable has been filled with data? I hope not.

By the way, if I Fill from XML my event handlers do get called as the tables 
are being filled - it is only when I go to Oracel, Sql Server and Sybase 
(yep, we use them all!) that the handlers do not get called.

Any help on this would be much appreciated.

Turns out this is a design feature!!!

I found the following note on MSDN

Most operations that add or delete rows do not raise the ColumnChanged and 
ColumnChanging events. However, the ReadXml method does raise ColumnChanged 
and ColumnChanging events, unless the XmlReadMode is set to DiffGram or is 
set to Auto when the XML document being read is a DiffGram.

see http://msdn2.microsoft.com/en-us/library/w9y9a401(VS.80).aspx


"Amir Tohidi" wrote:


> Hi
> 
> I am successfully filling my DataSet with data using an adaptor. Prior to 
> calling Fill(), I regsiter handler for the ColumnChanging event of each 
> DataTable in my DataSet because I want to do field level validation of each 
> data item.
> 
> Unfortunately, my event handler is NOT getting called! Does this mean that 
> DataTable events do not fire during a Fill() and that they only fire AFTER a 
> DataTable has been filled with data? I hope not.
> 
> By the way, if I Fill from XML my event handlers do get called as the tables 
> are being filled - it is only when I go to Oracel, Sql Server and Sybase 
> (yep, we use them all!) that the handlers do not get called.
> 
> Any help on this would be much appreciated.