This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Programming › .Net/C # › C# imports from an Excel table (10 tens of thousands of data) into a database ...
View: 25120|Reply: 4

[Interface] C# imports from Excel tables (100,000 data) into the database

[Copy link]
Posted on 9/30/2020 1:55:06 PM | | |
1. Process the scene
Excel sheets have 100,000 data
All of them need to be imported into the database
2. Implementation form
1) Get the data flow based on the URL
2) Perform for loop
Finally, it is provided to the client in the form of an interface
PS: It's slow, is there any better form of implementation?
       I have just joined the work and lack of experience, so I came to ask the gods




Previous:The difference between a restful patch and a put request
Next:Error when serializing or deserializing with JSON JavaScriptSerializer
Posted on 10/5/2020 11:11:16 AM |
There is no way, read it out and write it in
I wrote a data to excel, and I wanted to complete excel to the database, but I couldn't find the right time
Posted on 10/6/2020 8:39:48 PM |
The process is as follows:
  • Submit the Excel file post to the background interface
  • Read the Excel record into the memory table
  • Insert a table into the database via ado.net


References are as follows:

C# inserts a large amount of data through DataTable, and it only takes 3 seconds for 500,000 data
https://www.itsvse.com/thread-3292-1-1.html


Posted on 11/5/2020 11:14:12 PM |
Come on!
Posted on 12/1/2021 4:40:58 PM |
Not bad...
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com