Click here to Skip to main content
16,021,125 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi.

I have a C# project that use an Access DB as a data source to fill a DataGrid in my form application.

normally I use to select a value from a database's table, bring the value to the program, change him and then update the table whit the new valor, but in cases where i have more than one data whit the same name To perform an update I have to specify differences between the data in order to update the correctly one instead both.

So if I could perform some kind of real time bond between DB and DataGrid so that every alteration on the DataGrid is automatically transfer to DB my program would work perfectly. But I have no idea how to make this real time bond.

I found some help in this link but something is amiss or I don’t know where or how to use this code:

http://www.switchonthecode.com/tutorials/csharp-tutorial-binding-a-datagridview-to-a-database


If someone could give me a little help or even a tip I would be very grateful.

-thanks for attention.
Posted
Updated 5-Jul-10 7:39am
v2
Comments
Nishant Singh 6-Jul-10 2:16am    
Does the Access table which you are accessing have unique id for each record? if it has retrieve it and place it in a hidden column in your datagrid ,then while updating update according to id ....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900