create procedure c1
@tblName varchar(255), -- 表名
@PageSize int = 10, -- 页尺寸
@PageIndex int = 1 -- 页码
AS
declare @SQL varchar(5000) -- 主语句
begin
exec('select top '+@PageSize+' * from musiclist')
end如上这个存储,我在ASP程序里,怎么连接,让他在网页里显示出来??
@tblName varchar(255), -- 表名
@PageSize int = 10, -- 页尺寸
@PageIndex int = 1 -- 页码
AS
declare @SQL varchar(5000) -- 主语句
begin
exec('select top '+@PageSize+' * from musiclist')
end如上这个存储,我在ASP程序里,怎么连接,让他在网页里显示出来??
set conn=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd=111"
conn.Open strconn
set cmd.ActiveConnection=conn
cmd.CommandText="{call oneinput(?)}"
cmd.Parameters.Append cmd.CreateParameter("@aaa",adInteger ,adParamInput )
cmd("@aaa")=100
cmd.Execute()
%> -------------
<%set connection1 = Server.CreateObject("ADODB.Connection")
connection1.open ... '联接
set command1=Server.CreateObject("ADODB.command")
set command1.activeconnection=connection1
command1.commandtype=4
command1.commandtext="sp_1" 'SP 名
command1.parameters(1)=... '参数值
command1.parameters(2)=...
set recordset1=command1.execute()
%>?
ConnString="Provider=SQLOLEDB.1;Data Source=127.0.0.1;User ID=sa;Password=sa;Initial Catalog=web" 这个怎么换成
--------------------------------
set cmd=server.CreateObject("adodb.command")
strconn="dsn=pubs;uid=sa;pwd=111"
conn.Open strconn
---------------------------------------------------
strconn="dsn=pubs;uid=sa;pwd=111"
conn.Open strconn 这个dsn 是填IP吗
那数据库名,要填在哪里呀