小弟请教,VB与SQL的连接方法,听说有好几种吧,但是总是看不明白,请高手能给予指点,最好写点实例吧,先谢了!
解决方案 »
- Label滚动问题
- 100分求助,怎样从网页中提取信息?谢各位高手!!
- vb6 OLE控件中文件如何保存?
- 帮帮忙啊,急坏了!activereport报表问题啊?安装在WINDOWxp操作系统下时不会出现,但安装在winMe上时会出现的问题?
- 请问,我用C做了一个DLL参数是char*,char*没有返回值,如何用VB调用呀,声明如何写呢?
- 关于CBO连接到数据库的某一字段的问题
- 大问题!!!加急特快!!!(在线等待)
- 做一个网络连连看要多少钱?
- ACCESS2000中关于表与表间换算
- 如何在实现汉字或拼音的模糊查询(只有60分了,给50分)**欢迎讨论***
- 关于VB6+SP5的Data控件,连接带有密码的Access2000数据库的问题!!!
- 关于SQLSERVER连接的问题?
public rs as new ADODB.Recordset
Public Conn As New ADODB.Connection
public Strconnect as String
Strconnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=erp;Data Source=数据库名"
if conn.state=1 then conn.close
conn.open Strconnect
if rs.state=1 then rs.close
rs.open "select * from 表",conn,3,2
Dim QrySelect As rdoQuery
Dim sSql As String sSql="Select TEL, OFFICE, EMAIL From USERDATA "
Set QrySelect = g_Cn.CreateQuery("", sSql)
Set Rs = QrySelect.OpenResultset(rdOpenForwardOnly) Do Until Rs.EOF
'sTEL = Rs.rdoColumns("TEL") & ""
'sOFFICE = Rs.rdoColumns("OFFICE") & ""
'sEMAIL = Rs.rdoColumns("EMAIL") & ""
Rs.MoveNext
Loop
Set Rs = Nothing
Dim sSql As String On Error Resume Next
sSql="Insert Into USERDATA (TEL, OFFICE, EMAIL) " & _
"Values (?, ?, ?) "
Set QryInsert = g_Cn.CreateQuery("", sSql)
With QryInsert
'.rdoParameters(0).Type = rdTypeVARCHAR
'.rdoParameters(0) = sTEL
'.rdoParameters(1).Type = rdTypeVARCHAR
'.rdoParameters(1) = sOFFICE
'.rdoParameters(2).Type = rdTypeVARCHAR
'.rdoParameters(2) = sEMAIL
.Execute
End With
Dim sSql As String On Error Resume Next
sSql="Update USERDATA Set TEL = ? , OFFICE = ? , EMAIL = ? "
Set QryUpdate = g_Cn.CreateQuery("", sSql)
With QryUpdate
'.rdoParameters(0).Type = rdTypeVARCHAR
'.rdoParameters(0) = sTEL
'.rdoParameters(1).Type = rdTypeVARCHAR
'.rdoParameters(1) = sOFFICE
'.rdoParameters(2).Type = rdTypeVARCHAR
'.rdoParameters(2) = sEMAIL
.Execute
End With
conn.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=erp;Data Source=数据库名" '打开连接
conn.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=erp;Data Source=数据库名" '打开连接dim rs as new adodb.recordset '声明记录集rs.open "select * from Table",conn '利用已打开的连接和Sql语句填充记录集
http://expert.csdn.net/Expert/topic/2710/2710006.xml?temp=8.526248E-02