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 ...
I have tried googling for this but I am unsure on what to search for so I'm not getting the relevant results ...Code: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




Reply With Quote