I would like to make a vb.net datagrid that is always connected to an sqlserver table, kinda like make a change to an access database. When a change is made, the datagrid and backend database is always updated. Can someone lead me in the right direction (ie. what event should my updates be triggered from, what is the exact syntax for setting up the update commands, etc.). I don't want to have to click on a button to post my changes.
I have only used a datagrid to display data, and therefore it has always been disconnected from the database. I'm not sure what I need to do to have it connected.