dimanche 29 mars 2015

Design or Algorithm to Validate a Pattern of Data in DataTable C#

I have a very weird situation . I have a Excel file with data like


Header data_xyz

A|B|C

datA 1|2|3

datB 1|2|3

datC 1|2|3

.

.

.

.

END of Pattern

Recurring Pattern

Header data_xyz

A|B|C

datA 1|2|3

datB 1|2|3

datC 1|2|3

.

.

.

.

END of Pattern


Now we need to validate the data in columns A,B,C is Numeric and similarly check the datA,datB be not empty .


Rules will be 1)No of data rows in pattern differ 2)Each Pattern is defined so any data other than pattern will be invaid


Can we use some design to achieve the same .


Thanks in advance


Aucun commentaire:

Enregistrer un commentaire