這跟SQL沒什麼分別 Set DataGrid.DataSource=Rst只是連接數據庫的方法有點不同而已 Cn.ConnectionString = "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;" Cn.Open
不行啊,会弹出个"行集合不能做为标签",怎么办?代码是下面: STR = "Driver={MySQL ODBC 3.51 _ Driver};database=hmfp;Server=127.0.0.1;UID=root;port=3306;option=3" Dim conn1 As New ADODB.Connection Dim rec1 As New ADODB.Recordset conn1.ConnectionString = STR conn1.Open rec1.Open "select * from kh", conn1, adOpenDynamic, adLockOptimistic Set DataGrid1.DataSource = rec1
rec1.cursorlocation=aduseclient '<<<<<<<<<<<< rec1.Open "select * f ...
Set DataGrid.DataSource=Rst只是連接數據庫的方法有點不同而已
Cn.ConnectionString = "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
Cn.Open
STR = "Driver={MySQL ODBC 3.51 _ Driver};database=hmfp;Server=127.0.0.1;UID=root;port=3306;option=3"
Dim conn1 As New ADODB.Connection
Dim rec1 As New ADODB.Recordset
conn1.ConnectionString = STR
conn1.Open
rec1.Open "select * from kh", conn1, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rec1
rec1.Open "select * f ...