I have a database table, with columns and a priamary key.
I want to do the bulkcopy, from a datatable in my c#.
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?
Should I add the primary key to my datatable in my c#?
(if you need any code tell me pleae)
this is the datatable
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
I found the solution myself