Performance required to load data from excel to dbProblem.. Couldnot loop multiple records which time out failure
From excel values are loading into database.
3 conditions need to be satisfied for loading excel values to table.
a)There are certain columns.. If these column has 0 or improper null format,
that should change as " "
b)There is one Date column which should have current date
c)another column should append 2 other columns
eg) column3=column1 | column2 (ab= a | b)
If these conditions used in dot net loop, it is tough to loop inside lakhs of records
to satisfy this condition.
Is there way in dot net to make it fast or any excel validation possible which can be done in excel itself.