Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting data from an ACCESS DB

Status
Not open for further replies.

terryomag

Programmer
Aug 30, 2005
6
US
I have my data in an ACCESS database. I know how to use a Datagrid to display the data, but I need to get the contents of the rows and columns into arrays (in a VB.Net program) so I can manipulate the data. How can I do this? Sorry if this is a third-grade question.
 
Perhaps you should look at ADO Help and examine recordsets. They are the mechanism provided to retrieve and manipulate data from a database (or at least one of them.) Nothing really wrong with arrays but a lot of the things you may want to do with data like searching, sorting, filtering, updating, deleting, etc., are built into recordsets. You would need to write your own if you dump it into an array.
 
Um, since you're using vb.Net, you'll want to do two things:

1. Get familiar with the VB.Net forum; this forum is more for using databases from a VB6 context.

2. Look into ADO.Net help rather than ADO help, and examine the various objects (DataSet, DataReader, etc.) in that. Golom's advice about arrays is good for both environments.

HTH

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top