yah got it buddy @Loka625 , actually the problem occurs when the assignment meets this row
and it has empty value in it, so while trying to convert that as integer we were geting error like string " " cannot be converted to integer
So in that just use a validation before assigning in_Rownumber with a if condition like this
- if condition like this
Not String.IsNullOrEmpty(row(3))
if this condition passes, in then part of if condition assign like how you do now
else assign with
in_Rownumber = 0
Thats all buddy you are done. Kindly try and let know buddy @Loka625
Cheers @Loka625