What kind of data access?

[UrbaneSpaceman]

Hi

Another basic question I suspect but here goes...

I'm trying to read in records from an Access file and use one of the field values to populate records in a listbox.

I have a few issues with this :

1. I've managed to access the file using odbc and can dump all the data out to an xml file so I know it's opening OK but is this the best way? Should I really be using ole access.

2. Once I've accessed the database what is the best method of getting at the data?

3. How do I get the data into a regular text array? This seems to be the real pain!

Any help gratefully received.

Cheers

Mike

 

[Paszt]

1- Yes, you should be using OleDb classes with Access.
2- The best method depends on your circumstances. See this thread: DataSet or DataReader class
3- Using a dataReader

Read a bit about the differences with dataSets and dataReaders and if you have further questions, feel free to post .

 

[UrbaneSpaceman]

Thanks for that - think the problem was that I was overwhelmed with so many choices ;-) I'll have a play around later this evening and see if I can get things working.

Cheers

Mike