I'm experienced with VBA, but new to VB.net. I'm using VB express 2008 and want to know how to read/write from a local database (.sdf) using the equivalent of recordsets etc.
I have checked forums everywhere & sample code and can't find exactly what I'm after. Most sample code show you how to output data in the db table to the datagridview and allow you to modify directly from there. Rather than this, I want to read all records from a table into a recordset or array, then be able to add additional records or modify existing ones all from the recordset or array.
Can someone please help me with the above (supposedly) relatively simple request?? I don't know a lot about TableAdapters etc, so it would be appreciated if you could be simple with your response!!
Thanks so much in advance.