代码改变世界

vb DataGrid 显示数据库数据

2020-07-23 10:46  idea555  阅读(442)  评论(0)    收藏  举报

Private Sub Command1_Click()
On Error Resume Next

Dim objConn As ADODB.Connection
Dim objRs As ADODB.Recordset
Set objConn = New ADODB.Connection
Set objRs = New ADODB.Recordset

objConn.ConnectionString = "Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=Test;Data Source=PC-20190830UKXS\SQL2014"
objConn.Open
objRs.CursorLocation = adUseClient
objRs.Open "Select * from Company", objConn, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = objRs

If Err.Number <> 0 Then
MsgBox Err.Description
End If

On Error GoTo 0
End Sub