VB连接数据库

最新推荐文章于 2017-05-24 20:40:00 发布

梨落满秋

最新推荐文章于 2017-05-24 20:40:00 发布

阅读量1.1k

点赞数

文章标签： vb

本文链接：https://blog.csdn.net/cf643487053/article/details/54345403

版权

VB连接数据库
之一：ADO

首先要在“Project”中的“参照设定（N）”中追加Microsoft ActiveX Data Objects

Set conn = New ADODB.Connection
    conn.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=False;User ID=sa;password=softwise;Initial Catalog=VBNETtest;Data Source=DT-82-WIN7\SQL2005"
    conn.Open
    Set red = New ADODB.Recordset
    With red
    .ActiveConnection = conn
    .Source = "select * from tb_user"
    .CursorType = adOpenKeyset
    .LockType = adLockOptimistic
    .Open
    End With
    Set DataGrid1.DataSource = red