求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
------解决方案--------------------

探讨

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.Da……

------解决方案--------------------

探讨

建议你学C

------解决方案--------------------

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

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

相关推荐