I am copying excel file to mssql database's table, problem is this :
I have some informations in 4 rows but mssql database table has 13 rows. fisrt 4 rows has my information and 4-13 rows has null values. sbccm from 1 to 14. where is the problem I donw know but I want to save my information to DB without NULL values.
SqlBulkCopyColumnMapping sbccm1 = new SqlBulkCopyColumnMapping("Bildirim", "Bildirim");
sbc.ColumnMappings.Add(sbccm1);
SqlBulkCopyColumnMapping sbccm2 = new SqlBulkCopyColumnMapping("Bildirim Türü Adı", "CagriTipi");
sbc.ColumnMappings.Add(sbccm2);
SqlBulkCopyColumnMapping sbccm3 = new SqlBulkCopyColumnMapping("Malzeme", "Model");
sbc.ColumnMappings.Add(sbccm3);