Consider der are n rows. I need to divide the datatable for each 999 rows.
If the Excel sheets contains
1)1000 rows then two data tables need to be created one with 999 rows and the other with 1 row.
2)If the Excel contains less than 999 rows then the Single datatable is enough.
Please help me with this. Note : The EXcel Sheet contains the large amount of data
Hi, Thank you so much for your help.
But Can you also help me with how to know the DataTables count and add data into it accordingly.
The Row count is Random. We dont know the Count on before hand. We need to prepare enough datatables with 999 entries in each.
You can use Dt.Rows.Count which will return the rows count
According to that you can divide that rows to 999
Hope this may help you