I have excel which contains 18 rows in one column named “Document Number” i need to copy only 5 rows in this column and paste into application?
During second run i will do the same with remaining rows?
Thanks in Advance?
Is it only first 5 rows? or any specific sunch
Try with linq once you read it as dt
(from x in dt select x).Take(5).CopyToDataTable
Use Skip(5)in the second run
Yes only 5 rows in first run during second run remaining rows
"Try with linq once you read it as dt
(from x in dt select x).Take(5).CopyToDataTable
Use Skip(5)in the second run"
Where i can put this?
After the first Linq query it is taken as dt. Either write it in ur required application using for each row. Post this go for 2nd query.
OR
U can take this as array/list write to notepad. or use for each to paste in ur req application
Assign Activity
dt_query=(from x in dt select x).Take(5).CopyToDataTable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.