您当前的位置: 我这两天才刚接触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