I want to do the bulkcopy, from a datatable in my c#.
I have a database table, with columns and a primary key.
When I have primary key in my table, I got exception because the table has 6 columns, while my datatable has just 5.
what should I do please?
private DataTable getBasicDataTable()
{
DataTable dataTable = new DataTable();
dataTable.Clear();
dataTable.Columns.Add("customerID", typeof(int));
dataTable.Columns.Add("firstName", typeof(string));
dataTable.Columns.Add("lastName", typeof(string));
dataTable.Columns.Add("showsNumber", typeof(int));
dataTable.Columns.Add("visitNumber", typeof(int));
dataTable.Columns.Add("cancellation", typeof(int));
return dataTable;
}
but in my database table, I have the exact same columns, but with extra ID primary key,
Note: when I delete my primary key in the database, everything works perfectly
Anonymous User
25-May-2015I found the solution myself
bc.ColumnMappings.Add("customerID","customerID");sbc.ColumnMappings.Add("firstName", "firstName");
sbc.ColumnMappings.Add("lastName", "lastName");
sbc.ColumnMappings.Add("showsNumber","showsNumber");
sbc.ColumnMappings.Add("visitNumber","visitNumber");
sbc.ColumnMappings.Add("cancellation","cancellation");