Jun 22, 2018 05:24 AM|Yohann Lu|LINK
You can refer the following sample which use ADO.Net SqlCommand ExecuteNonQuery method in C# and VB.Net to perform Insert, Update and Delete operations.
ExecuteNonQuery: Insert Update and Delete examples in C# and VB.Net
Or, use a stored Procedure in ADO.Net to insert datatable rows into the SQL table
Insert multiple rows into SQL Server database:
Note : remaining 6 columns cell may be blank or null.
You can set the 6 columns default values as null.