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#?
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 ...