怎么用VB读取SQL表中一列数据

2023-12-20 21:22:18
有1个网友回答
网友(1):

你是用什么连接到SQL的?ADO吗?
如果ADO的话
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "connection string"
Set rs = conn.Execute("select [Epassword] from [Emplyee]")
Do Until rs.EOF
x(i) = rs(0)
rs.MoveNext
i = i + 1
Loop