Hi I want to make dynamic upload excell in C# to SQL Server database (use .net core 5.1, Visual Studio 2019)
With this function
1. If they fill ID in excell then it will update the data
2. If they don't fill ID in excell then it will insert the data (ID will auto increment but don't use auto increment sql server. Just select max from last ID and add it one by one).
Insert must use bulk insert so the performance fast.
Field Name in excell header will be same with field name in sql server
Something like this: [login to view URL]
21 years SQL server expert, yeas c# bulk insert command will be used , everything is ready for this application , just need excel and SQL server field mapping , we can discuss to start