VB6.0+SQL Server+ADODB

直连，我个人喜欢这种方式。1.在工程里需要引用ADO的Libary，具体就得看ADO的版本了，在前面打钩就可以了。2.Dim SQLcon As New ADODB.ConnectionDim SQLrec As ADODB.RecordsetdbUser = "." dbPassword = ""dbName = "Northwind"dbServer = "127.0.0.1"SQLcon.Open "Provider=SQLOLEDB.1; User ID=" & dbUser & ";Password=" & dbPassword & ";Initial Catalog=" & dbName & "; Data Source=" & dbServerSQLQuery = "Select * from employees ORDER BY FirstName ASC"SQLcon.Execute (SQLQuery) '指执行，不返回结果SQLrec.Open "select * from titles where title like '%h'",SQLcon ADOGrid1.ShowData SQLrec

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!