I can make a DAO recordset in VB6/Access do anything - add data, clean data, move data, get data dressed in the morning and take it to school. But I don't even know where to start in .NET.
I'm not having any problems retrieving data from the database, but what do real people do when they need to edit data and put it back?
What's the easiest and most direct way to edit, update and append data into related tables in .NET and SQL Server?
try to use oledbConnection , oledbCommand and oledbDataReader
from System.data.oledb
if you are using sqlserver DB then from System.data.SqlClient
use SqlConnection , sqlCommand and sqlDataReader
A natural progression IMO from DAO is ADO.net. I think you would find it pretty easy to pick up having the understanding/foundation of DAO. It uses DataAdapters and DataSets similar to recordsets. Modifying Data in ADO.NET.
I would suggest looking into Linq when you get a chance.
Is there a reason why ms-access was added as a tag here? It seems to me that the question has nothing but the most trivial relevance to Access, since once you're working with .NET, Access is completely out of the picture.
--
David W. Fenton
David Fenton Associates