Need help using VB.NET to retrieve ACCESS data.
Posted on 2004-10-21
I am a complete newbie to VB.NET programming. All I am trying to do is retrieve all the data from an ACCESS database and then loop through it to store it in an array.
Maybe I dont need to store it in an array. The concepts of datasets are strange to me. How do I access specific records in the datasets. I have a book on the subject, but it is only using bound controls (the datagrid). I don't want to use the bound controls at all.
I have set up my database connection(OleDbConnection1) and data adapter(OleDbAdapter1). I also have a dataset ("Blinds_Dataset"). The table is very simple. an ID (key) column, and two data columns.
This is so frustrating compared to the old way of SQL into recordsets or arrays. ((its been 10 years since I wrote even one line of code =). )