7451
社区成员
- 主页
...全文
请发表友善的回复…
发表回复
lxcc 2002-12-30
dim conn as ADODB.Connection
dim strSql as string
'Text1 放存储过程名称
strSql=Text1 & " @para1='" & para1_value & "'"& " @para2='" & para2_value & "'" ......
dim strSql as string
'Text1 放存储过程名称
strSql=Text1 & " @para1='" & para1_value & "'"& " @para2='" & para2_value & "'" ......
hitwy1979 2002-12-30
同意楼上的，对了数据库连接字符串是：provide="数据库引擎";user name="用户名";password="密码"；data source="机器IP";initial catalog="数据库名"。对了在告诉你一下，会操纵数据库不教高手！！！
interdog 2002-12-30
dim m_Con as new adodb.connection
dim m_Cmd as new adodb.command
dim m_Rst as new adodb.recordset
with m_Con
.connectionstring="数据库连接字串"
.open
end with
with m_Cmd
.activeconnection=m_Con
.commandtype=adCmdStoredProc
.commandtext="存储过程名"
end with
set m_Rst=m_Cmd.execute
dim m_Cmd as new adodb.command
dim m_Rst as new adodb.recordset
with m_Con
.connectionstring="数据库连接字串"
.open
end with
with m_Cmd
.activeconnection=m_Con
.commandtype=adCmdStoredProc
.commandtext="存储过程名"
end with
set m_Rst=m_Cmd.execute
watt 2002-12-30
What are you intput into textbox? procedure's name or procedure's script?
ttyp 2002-12-30
conn.Execute "Exec 存储过程名"