how do I show info from a database connection

[casualrich]

hi

as you of you know Im doing this assignment for uni and I have had trouble connecting the database but I have now solved that problem!!!

I jsut now need to now how i can display the information from table I have called from the databse and show it in my VB project

I have used a data grid view but how do I declaie that in my code? and get the data to show onto it?

    GroupBox2.Visible = True
        Dim dt As New DataTable
        Dim commStr As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
                                "Data Source= EngineerJobs01.MDB"
        Dim sqlStr As String = "SELECT * FROM [Engineers]"
        Dim DataAdapter As New OleDb.OleDbDataAdapter(sqlStr, commStr)
        DataAdapter.Fill(dt)
        DataAdapter.Dispose()

 

[casualrich]

any1 please help me please!!

 

[MattP]

Set the DataGridView's DataSource to your DataTable

Me.DataGridView1.DataSource = dt

 

[casualrich]

thanks for that it works now brill!