[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

intercept data adapter fill method events

Hi all,

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)

1 Solution
Bob LearnedCommented:
Would it be possible to process that through the database system (SQL statements) instead?

simplyamazingAuthor Commented:
Actually, yes, this is already what I do now for any new DBs created (using SQL's "ISNULL" for null date fields in SPs and CASTing timestamps to bigints, etc.).  My question is probably moot since I could never use the update or insert via a dataset regardless.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now