Public Sub updatedatagrid(ByRef DataGrid1 As datagrid)
Dim rs As New ADODB.Recordset
Dim cnn As String
cn.Open
DataGrid1.RecordSelectors = False '取消第一列
DataGrid1.MarqueeStyle = dbgHighlightRowRaiseCell
rs.CursorLocation = adUseClient
cnn = "select * from borrow"
rs.Open cnn, cn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs
MsgBox rs.RecordCount rs.Close
cn.Close
DataGrid1.Refresh
End Sub
Dim rs As New ADODB.Recordset
Dim cnn As String
cn.Open
DataGrid1.RecordSelectors = False '取消第一列
DataGrid1.MarqueeStyle = dbgHighlightRowRaiseCell
rs.CursorLocation = adUseClient
cnn = "select * from borrow"
rs.Open cnn, cn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs
MsgBox rs.RecordCount rs.Close
cn.Close
DataGrid1.Refresh
End Sub
rs.Close
cn.Close
DataGrid1.Refresh
这三句不要