DataGrid + ADODB.Recordset:Dim adoConnection As New adodb.Connection
Dim adoRecordset As New adodb.Recordset
adoConnection.Open "Provider=MSDASQL.1;Driver={MySQL};host=localhost;DataBase=test;UID=monty"
adoRecordset.CursorLocation = adUseClient
adoRecordset.Open "SELECT * FROM mytable1", adoConnection ', adOpenKeyset
'Debug.Print adoRecordset.GetString
Set DataGrid1.DataSource = adoRecordset
Dim adoRecordset As New adodb.Recordset
adoConnection.Open "Provider=MSDASQL.1;Driver={MySQL};host=localhost;DataBase=test;UID=monty"
adoRecordset.CursorLocation = adUseClient
adoRecordset.Open "SELECT * FROM mytable1", adoConnection ', adOpenKeyset
'Debug.Print adoRecordset.GetString
Set DataGrid1.DataSource = adoRecordset
说的详细点好吗? 谢了!
mysql
>show databases;
>use dbname;
>show tables;
>select * from tbname;