打开VB6,选 外接程序--外接程序管理器--VB6数据窗体向导
解决方案 »
- 请教高人们:大家找源码一般都到哪里去找的?太基础的码不算.帮介绍下,谢谢!!
- 我不会用OFFICE里面的宏,有谁有电子资料推荐一下
- 快点帮忙 小弟我有急事………………………………
- 请问有知道要响应listview里item的双击应该怎么做吗?给点帮助啊
- 请教高手,类似于主细表的报表制作
- 请问高手关于数据库程序不能顺利关闭的问题
- 如何获得硬盘序列号
- 还有活跃的吗,求帮助
- 请问,串口通讯中如何控制端口各个脚的电位
- 为什么这个RegisterServiceProcess-win98的api不能在w2k运行,难道哪个kXX.dll找不到接口,怎么解决
- vb里有画贝塞尔曲线的函数吗?该怎么用啊?
- 不知道大家何时转到vb.net? (散 分)
dim Conn as connection
Conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=要数据库名;Data Source=服务器名"
定义好连接后就可以访问数据库了,如查询:
dim rs as recordset
set rs=new recordset
rs.open "select * form biao",Conn,adOpenDynamic, adLockReadOnly
adoCN.Open "ConnectString"引用最新版本的ADO对象库
With cn
.CursorLocation = adUseClient
.Open "Provider=SQLOLEDB;Server=" + ServerName + ";Database=myinvoice;Uid=" + ServerID + ";Pwd=" + ServerPassword + ";"
end with
dim Cnn as New connection
Cnn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器名"
定义好连接后就可以访问数据库了,如查询:
dim rs as New recordset
rs.open "select * form 表名",Cnn,adOpenDynamic, adLockReadOnly
2、定义 adoconnection As New ADODB.Connection然后:
Dim servername As String, dataname As String, user As String, password As String,sql as string '设置服务器参数
servername = "HongBin"
dataname = "jdxt"
user = "sa"
password = "123456"
sql = "Provider=SQLOLEDB.1;User ID=" + user + ";Initial catalog=" + dataname + ";Data Source=" + servername + ";PWD=" + password With adoconnection
.ConnectionString = sql
.Open
End With
With adorecordset
.ActiveConnection = adoconnection
.CursorType = adOpenKeyset '根据需要自已选
.LockType = adLockReadOnly '根据需要自已选
.Source = sql
.Open
End With
这样就可以把jdxt中的spk表打开。