VB与SQl连接的方法及步骤

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