I know ASP.NET very well and VB.NET, and am just starting with Windows Forms. I know ADO.NET, but dislike using wizards provided (must be a control freak). I want to create a simple datagrid for use for data-entry which will work just like Access or SQL Server table (ie data entered into datagrid is added immediately to underlying table).
If I create a dataset/datatable and bind form to that, I'll have to write the records back to the underlying database. Can I bind data directly to Access/SQL Server table to avoid user having to click on an Update button? Failing that, should I be using a dataadapter?