Last post Mar 09, 2021 04:11 AM by yij sun
Mar 08, 2021 06:18 PM|callykalpana|LINK
I have a got a datatable generated from an Excel sheet. The datatable is then displayed in a gridview. Now I have a choice of inserting data from the datatable or the gridview to the sql database. For each row, there a destination table in the database.
What is the best way of achieving this feature. Appreciate any feedback, thanks.
Mar 09, 2021 04:11 AM|yij sun|LINK
As far as I think,your solution is this:
1.When you got the data from an Excel sheet, you could create a new column to define special datatables. You could check which row go to which databales.
2.When you insert data from datatables,you could to write the different sql database routes or tablename.
3.The data you need to insert the same database,you could traverse these data.