'得到表名在数据库里的编号
Rs.Open "select top 1 id from sysobjects where xtype='u' and name='school_pupilinfo'", Conn, 1, 1
'通过编号得到表的字段
If Not Rs.EOF Then
Set Reco=server.CreateObject("adodb.recordset")
Set Reco = Conn.Execute("select name from syscolumns where id=" & Rs("id") & " ORDER BY colid")
<html>
<head><title>演示DSN连接数据库</title></head>
<body>
<%
'server对象的createobject方法建立conection对象
set conn=server.createobject("adodb.connection")
'DSN表示服务器端设置的DNS名称
'uid表示用户帐号
'pwd表示用户密码
'database表示在数据库服务器上的一个database的名称
conn.connectionstring="DSN=sqlDB;UID=sa;PWD=000;Database=sqlDB"
'判断数据库状态
if conn.state=1 then
response.write("数据库成功打开<BR><BR>")
end if
%>
<script language="javascript">
alert("单击确定,关闭数据库");
</script>
<%
if conn.state=0 then
response.write("数据库已经关闭")
end if
'释放connection对象,关闭数据库
set conn=nothing
%>
</body>
</html>
Set Rs1=server.CreateObject("adodb.recordset")
Rs1.Open "select top 1 id from sysobjects where xtype='u' and name='school_pupilinfo'", Conn, 1, 1
If Not Rs1.EOF Then
Set Rs_sql=server.CreateObject("adodb.recordset")
Set Rs_sql = Conn.Execute("select name from syscolumns where id=" & Rs("id") & " ORDER BY colid")
Do While Not Rs_sql.EOF
if lcase(Rs_sql("Name"))<>"classid" and lcase(rs_sql("name"))<>"id" and lcase(rs_sql("name"))<>"stu_image" and lcase(Rs_sql("Name"))<>"status" then
Set Rs=server.CreateObject("adodb.recordset")
Rs.Open "select top 1 id from sysobjects where xtype='u' and name='school_pupilinfo'", Conn, 1, 1
If Not Rs.EOF Then
Set Reco=server.CreateObject("adodb.recordset")
Set Reco = Conn.Execute("select name from syscolumns where id=" & Rs("id") & " ORDER BY colid")
Do While Not Reco.EOF
if lcase(reco("Name"))<>"classid" and lcase(reco("name"))<>"id" and lcase(reco("name"))<>"stu_image" and lcase(reco("Name"))<>"status" then
end if
Reco.MoveNext
Loop
Reco.Close
End If
'用二维数组把SQLSERVER里的字段装起来
dim myarray()
ReDim myarray(2,0)
Set Rs1=server.CreateObject("adodb.recordset")
Rs1.Open "select top 1 id from sysobjects where xtype='u' and name='school_pupilinfo'", Conn, 1, 1
If Not Rs1.EOF Then
Set Rs_sql=server.CreateObject("adodb.recordset")
Set Rs_sql = Conn.Execute("select name from syscolumns where id=" & Rs("id") & " ORDER BY colid")
Do While Not Rs_sql.EOF
if lcase(Rs_sql("Name"))<>"classid" and lcase(rs_sql("name"))<>"id" and lcase(rs_sql("name"))<>"stu_image" and lcase(Rs_sql("Name"))<>"status" then