'需要引用ADO(工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号)) Private Sub Command1_Click() Dim cn As New ADODB.Connection, rs As New ADODB.Recordset Dim i%, j%, arrData As Variant, strTmp As String cn.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=ljx"
rs.Open "select * from t1", cn, 1, 1
arrData = rs.GetRows '把数值赋给二维数组 For i = LBound(arrData, 2) To UBound(arrData, 2) strTmp = "" For j = LBound(arrData, 1) To UBound(arrData, 1) strTmp = strTmp & vbTab & arrData(j, i) Next Debug.Print strTmp '打印数组的数据 Next rs.Close cn.Close Set rs = Nothing Set cn = NothingEnd Sub
Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
Dim i%, j%, arrData As Variant, strTmp As String
cn.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=ljx"
rs.Open "select * from t1", cn, 1, 1
arrData = rs.GetRows '把数值赋给二维数组
For i = LBound(arrData, 2) To UBound(arrData, 2)
strTmp = ""
For j = LBound(arrData, 1) To UBound(arrData, 1)
strTmp = strTmp & vbTab & arrData(j, i)
Next
Debug.Print strTmp '打印数组的数据
Next
rs.Close
cn.Close
Set rs = Nothing
Set cn = NothingEnd Sub