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