MS Access VB.NET

[fabmsg]

Hi!
I have and Microsoft Access database that I want to access with VB.NET.
What is the best way? I know how to use the Data Grid but I'm not sure what are the binding sources and Dataset...can I use them to do a query in the MS Access?
Right now I'm using something similar to:

    Dim conexao As New OleDb.OleDbConnection
        Dim comando As New OleDb.OleDbCommand
        Dim adaptador As New OleDb.OleDbDataAdapter
        Dim dados As New DataTable
        conexao = New OleDb.OleDbConnection
        conexao.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\DB.accdb'"
        Try
            conexao.Open()
            Try
                comando.Connection = conexao
                adaptador.SelectCommand = comando

                Dim query = "SELECT Name, Diameter FROM Construction WHERE  (Name LIKE 'PF')"
                Dim dc = New OleDb.OleDbCommand(query, conexao)
                Dim rows As OleDb.OleDbDataReader
                rows = dc.ExecuteReader

???? how can I get the rows values? I'm not being able to to that...

            Catch erro As Exception
                MessageBox.Show("Error")
            End Try
        Catch erro As Exception
            MessageBox.Show("Error")
        Finally
            conexao.Dispose()
        End Try

[dolot]

A data reader is a forward-only data reader used to read the data at high speed. However, it can't be used to bind to a DataGridView. So if you're wanting to bind to a datagridview, you'll need something like this:

Dim DT as DataTable
 
adaptador.Fill(DT)
 
DataGridView1.DataSource = DT

[fabmsg]

A data reader is a forward-only data reader used to read the data at high speed. However, it can't be used to bind to a DataGridView. So if you're wanting to bind to a datagridview, you'll need something like this:

Dim DT as DataTable
 
adaptador.Fill(DT)
 
DataGridView1.DataSource = DT

hi! thanks for you help.
I don't want to use a data grid. I want to pass an value from one column to a variable.. can i use data reader? if so how?

thanks a lot!

[dolot]

Maybe something like this:

Using reader As OleDb.OleDbDataReader = dc.ExecuteReader
            While reader.Read
                'do something...
                Dim I As Integer
                I = reader!Column1
            End While
        End Using

[techgnome]

or not... that's the old ADO way....
ad

o.
net doesn't support the ! notation.

For this you'll use the rows.GetString(0) to get the first column. you wouls use .getXXXX() where XXXX is the type the column is, string, decimal, date, etc... and then pass it the ordinal position of the column you want.


this is all in the documentation https://msdn.microsoft.com/en-us/lib...vs.110%29.aspx

-tg

[moonman239]

FYI, Visual Studio can add database connections automatically. Google "add data source visual studio (visual studio version here)".