problem in connecting MS access with C#

Question

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

Mamta M · Answer

The error probably occurred because you are trying to insert null values into non-null columns. Hence please check the structure of your tables verify which columns are null ensure that you are not inserting nulls into those columns and then run the program. The problem is not in the logic or approach but in the data you are inserting and the structure of your table. A good book may be: Practical Database Programming with Visual C#.Net http://www.amazon.com/Practical-Database-Programming-Visual-NET/dp/0470467274