Hello,

I would require suggestion on how to insert the datatable values to the SQL table in VB.Net

My datatable contains 10 columns with multiple rows of data and SQL table has 12 columns.

When I insert a row data, I need to pass other 2 column values along with 10 datatable column values and finally, need to insert 12 columns to SQL table by calling store procedure or direct query.

Please guide me on this scenario.