c@ 2008 express - datagridview will not remove the record from database even though it disappears from DGV temporarily

Question

Can someone help me understand why if I select a row in the the DGVand delete it, it disappears but when I close my app and reopen (or refresh the databindings) it pops back up.

I have a customers table with relationships and the only one that is giving me this problem is one that I created in the same way as the others.

Modifications to this DGV give me the same problem.

Any help greatly appreciated

Thanks in advance

Answer 1

refer This Link

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Answer 2

Thanks,
Can you tell me how to use this command with a textbox

regionTableAdapter.Insert(5, "NorthWestern");

can i write textbox1.text, textbox2.text instead of 5 and Northwestern. I tried it but it gave me error( I was explicitly converting the textboxes to int32)

????

Answer 3

Hi Waqas,

Please refer the below links

http://www.c-sharpcorner.com/uploadfile/mimrantaj/connect-to-access-database-in-C-Sharp-and-ado-net/

http://msdn.microsoft.com/en-us/library/aa288452%28v=vs.71%29.aspx

http://www.codeproject.com/Articles/24043/Simple-Movie-Database-in-C-using-Microsoft-Access

Thanks