求VB2010与数据库连接操作解决方案

求VB2010与数据库连接操作
我这两天才刚接触VB2010 新手中的新手 以前学过VB6.0
 求 如何在VB2010中进行查询(已经连接好数据库)并且将查询的结果返回在datagridview控件中

[解决办法]
Dim Adapter As New OleDbDataAdapter
 Dim SQL = "select * from table"
 Adapter.SelectCommand = New OleDbCommand(SQL, conn)
 Dim table1 as DataTable =New DataTable()
 Adapter.Fill(Table1)
 Me.DataGridView1.DataSource =Table1
[解决办法]

VB.NET code

Sub Test()        Dim connstr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "D:\temp\test.accdb"        Dim sql As String = "select * from " + "TableName"        Dim dt As New DataTable        Dim dataAda As New OleDb.OleDbDataAdapter(sql, connstr)        dt.Clear()        dataAda.Fill(dt)        dataAda.Dispose()[code=VB.NET]        DataGridView1.DataSource = dt    End Sub