Using SqlBulkCopy Error: 1 DataSet does not support system.nullable<>,2. The given value of String type from the data source cannot be converted to the type nvarchar of the specified destination column.

First question,

Workaround: Dt.addcolunms ("Name", "type"), type cannot be typeof (int?), typeof (DateTime?) A nullable value type. The string can be. So the nullable value type is changed to not be empty.

Second question,

WORKAROUND: Bulkcopy.writetoserver (DT), first check the DT column type is not wrong?, if no problem, then check the order of the DT columns and database columns in the same order.

I met these two problems to solve the problem. Some friends might say, my DataTable column name is not a field name, why order consistent? In fact, he is in order, not according to the column name.

If there are errors, please note.

Using SqlBulkCopy Error: 1 DataSet does not support system.nullable<>,2. The given value of String type from the data source cannot be converted to the type nvarchar of the specified destination column.