問題描述
ADODB.Recordset 數據無法綁定到 datagridview (ADODB.Recordset data cannot bind into datagridview)
i wan to bind data from recordset into data grid view, but the data cannot show in the grid view, i try count the row, there are 2 rows of data, but cannot bind into grid view
If Not rs.EOF Then
DataGridView1.DataSource = rs
DataGridView1.Refresh()
Else
MsgBox("Record Not Founds " & txtSearch.Text, MsgBoxStyle.OkOnly)
End If
‑‑‑‑‑
參考解法
方法 1:
You can't bind a DataGridView to an ADODB.Recordset. If you can't change the data source to ADO.Net then you will have to pre‑process the recordset into something the DataGridView can bind to like a DataTable, or alternatively just write the rows in manually.
方法 2:
<p>@Stuart's answer is correct. </p>
You could use the code on this site to convert your recordset
to a datatable
but note the problem I experienced here when I upgraded to .NET 4
Your best solution is to query your data with something that can handle datatables/datasets ‑ what is your db?
(by sozai、stuartd、Matt Wilko)