problem in connecting MS access with C#

Jan 3 2012 6:44 AM
Hi all

  Please i have a problem in connecting MS access with C#, shortly i have an array "Description[count]" containing data all i need to pass this data to a table "StockList" using Tableadaptor and using this "StockListTA.Insert("//Code", "//Dim", "//Flg", Description[count], "//Price", "//Qty","//Note");

and i did not using a relations between table in my database in MS access
and when i run the program it stops in StockListTA.Insert("", "", "", Description[count], "", "",""); tell me "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

please i need a help in this problem

and also i need any book pdf talking and learning about C# with MS Access

Best regards

Answers (1)