<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>
解决方案 »
- 用DTS从SQL2005往ORACLE 10G导入的时候报错.. ORA-01017:用户名/口令无效;登录被拒绝
- 在Windows98上安装SQLServer2000的问题
- SQL如何计算某列有多少个字符?
- 一般情况下数据库中的表是怎么打印出来?
- sql
- 从2000到2005转移数据库出现问题 无法初始化连接服务器"(null)"的OLEDB访问接口"MSDASQL"的数据源对象
- 打开端口问题
- 求一条SQL语句!
- 关于在SQL SERVER 6。5中应用程序删除不掉用户的问题
- 如何将word编辑的文件存入sql server数据库一个表中的TEXT字段中,存入后如何从表中提取该字段?
- SQL6.5 有时当机,高分求救!!!
- 多表查寻
asp,php,c#,perl等????
<%
const adCmdText = 1
const RecordsAffected = 0Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=yourDSN;UID=sa;PWD="CommandText = "Insert into tablename(Fields...) values(...)"conn.Execute CommandText,RecordsAffected,adCmdTextSet conn = nothing
%>删除和查找,只需把CommandText的SQL语句改掉就可以了!
不过,注意数据库字段的值的类型一定要指定正确!