datagridview动态绑定ado.recordset怎么不能显示数据?
来源:百度知道 编辑:UC知道 时间:2024/05/22 04:30:02
datagridview动态绑定ado.recordset怎么不能显示数据?我用的是vs2008.控件是datagridview而不是datagrid.
m_Conn = New ADODB.Connection
m_Conn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
Call m_Conn.Open(m_ConString)
m_Rs = New ADODB.Recordset
m_Rs.Open("select * from H_MEDICAL", m_Conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockReadOnly)
H_MEDICALDataGridView.AutoGenerateColumns = True
H_MEDICALDataGridView.DataSource = m_Rs
H_MEDICALDataGridView.Refresh()
以前我用vb6的时候都可以绑定recordset现在不灵了。
m_Conn = New ADODB.Connection
m_Conn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
Call m_Conn.Open(m_ConString)
m_Rs = New ADODB.Recordset
m_Rs.Open("select * from H_MEDICAL", m_Conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockReadOnly)
H_MEDICALDataGridView.AutoGenerateColumns = True
H_MEDICALDataGridView.DataSource = m_Rs
H_MEDICALDataGridView.Refresh()
以前我用vb6的时候都可以绑定recordset现在不灵了。
在open m_Rs之前,试试加入m_Rs.CursorLocation=adUseClient.
没看明白为什么要声明一个ADO连接,然后打开.
在后面加上H_MEDICALDataGridView.DataBind();应该就可以了