title: Dataset validation for type ( C# .NET )
body: <p>Im working with dataSets validation in my project. I'm doing validation when DataTable_ColumnChanged event fires in partial class of dataTable, and its doing its job, but i would like to also validate datatype mismach on dataSet level, not UI, to provide custom error message. If [someID] expects number, but someone enters string in textbox for instance.</p>
  
  <p>The problem is, dataSet is handling that type of error somewhere before DataTable_ColumnChanged event fires, and never change column, I understand that.</p>
  
  <p>So the question is where and how to intercept it. I want to handle that in partial dataTable class, wrap into a property or something, but VS generated bunch of code and i dont know where to look :) Thanks.</p>