高手接招！！！

[lzfile]

我在一个textbox中输入一个存储过程。
如何用ADO执行？能否举例？

[ttyp]

conn.Execute "Exec 存储过程名"

[watt]

What are you intput into textbox? procedure's name or procedure's script?

[interdog]

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

[hitwy1979]

同意楼上的，对了数据库连接字符串是：provide="数据库引擎";user name="用户名";password="密码"；data source="机器IP";initial catalog="数据库名"。对了在告诉你一下，会操纵数据库不教高手！！！

[lxcc]

dim conn as ADODB.Connection
dim strSql as string
'Text1 放存储过程名称
strSql=Text1 & " @para1='" & para1_value & "'"& " @para2='" & para2_value & "'" ......