Cell level validation in Datatable/Dataset

Sep 30, 2010 at 6:14 PM
Edited Sep 30, 2010 at 6:15 PM

Hi.. i have imported a excel in to datatable which contains 5 columns and some thousand rows.

I have to do two level validation. 

First i have to check whether the column belongs to specific datatype. 

If so, then i need to check each and every cell in that column for the constraints. 

How can i achieve this using wpf c#?

 

Example:

Name   No   Num   Value
apple    1      3       10.9
ruby     10    3        4.5
john      4    11       2.5


i have to find the datatype first and here the second colum contains No which is of datatype 'int' 
and the constraints are 0 - 9. As in second row it has value 10 in it, i want to find that value
and replace it with null value. Any cell out of the constraint property should be replaced with null values
Please help me ...