VB连接MYSQL的代码设计
下面用recordset.open方法运行命令:
DIM cn as NEW ADODB.Connection
DIM rst as NEW ADODB.Recordset
cn.ConnectionString = "DSN=myodbc;uid=root;pwd=19941214"
cn.Open
cn.CursorLocation = adUseClient ‘使用本地游标库提供的客户端游标
rst.Open "select * from singer", cn, adOpenKeyset, adLockOptimistic
Call refreshform