代码如下
<%
dim strUserID,strPwd,strDbName,strConn
strUserID = "sa"
strPwd = "" 'syokuzai
strDbName = "AGE_777"
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & strUserID & ";PWD=" & strPwd & ";Initial Catalog=" & strDbName & ";Data Source=."
dim conn,cmd
Set conn = Server.CreateObject("ADODB.Connection")
Set cmd = Server.CreateObject("ADODB.Command")
conn.open strConn cmd.ActiveConnection=strConn
cmd.CommandText = "PR_PGE100101"
cmd.CommandType = CommandType.StoredProcedure 'cmd =New SqlCommand("PR_PGE100101",conn);
'cmd.CommandType=CommandType.StoredProcedure;
cmd.ExecuteNonQuery()
%>
不需要返回值,请调试好告知错误,谢谢了先
<%
dim strUserID,strPwd,strDbName,strConn
strUserID = "sa"
strPwd = "" 'syokuzai
strDbName = "AGE_777"
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & strUserID & ";PWD=" & strPwd & ";Initial Catalog=" & strDbName & ";Data Source=."
dim conn,cmd
Set conn = Server.CreateObject("ADODB.Connection")
Set cmd = Server.CreateObject("ADODB.Command")
conn.open strConn cmd.ActiveConnection=strConn
cmd.CommandText = "PR_PGE100101"
cmd.CommandType = CommandType.StoredProcedure 'cmd =New SqlCommand("PR_PGE100101",conn);
'cmd.CommandType=CommandType.StoredProcedure;
cmd.ExecuteNonQuery()
%>
不需要返回值,请调试好告知错误,谢谢了先
解决方案 »
- DateTime 相加
- 求一个sql 很烦恼,就2个关联表
- 新手问题
- 关于:bs结构系统,一个用户只能同时一人在线的实现
- csdn上有网页设计的论坛或者社区吗
- 关于名称空间的!!!
- 调试时出现:"拒绝了对对象 'sp_sdidebug'(数据库 'master',所有者 'dbo')的 EXECUTE 权限。",该怎么办?
- 生成缩率图之后删除原来的图片,出现该图片无法删除,另一进程正在用,怎么办?
- 齐家你在那 bobcat79在等待!!!
- 如何在ASP.NET中使用CRYSTAL 报表(水晶报表)
- asp.net中AJAX不能访问Request.QueryString吗?
- 系统不支持“gbk”编码??在线等,解决即给分!!
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=new SqlCommand(storeName,parameters);
da.Fill(ds,table);
conn.Close();
conn.Dispose();
return ds;