[2005] From Access to String or to Array

[Righteous_trespasser]

I have an access Database that I want to read some data from, now I know how to connect to the database and Open and close it, but from there I am stuck, all I want to do is take a specific column in one of the Tables and read out of it row by row and add it to a string ... So this is what I have so far ...

Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DBCon As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source= *my database source*")
        DBCon.Open()

**here I need to go through each row and add the column's data to a string or an array (I'd prefer it being a string)**

        DBCon.Close()
End Sub

I have tried googling for this but I am unsure on what to search for so I'm not getting the relevant results ...

[nmadd]

Hi there,
Here are some good links to help you get started. Read the first article first. Good luck.
http://vbforums.com/showthread.php?t=469872
http://msdn2.microsoft.com/en-us/lib...60(vs.80).aspx

[jmcilhinney]

http://www.vbforums.com/showthread.php?t=469872

The second example will be of most interest to you.

Edit: Shazzam!

[Righteous_trespasser]

Oh my!!! What legends you are ...

@ jmcilhinney: I thought I had lots of posts at ozzu.com ... but I was wrong ... lol ... nice