欢迎光临
我们一直在努力

利用C#在SQL Server2000存取图像 For Window-ASP教程,ASP应用

建站超值云服务器,限时71元/月

关键代码:

<%

set conn=server.createobject("adodb.connection")

connstr="dbq="+server.mappath("db1.mdb")+";defaultdir=;driver={microsoft access driver (*.mdb)};"

conn.open connstr

function menu(id)

set rs=server.createobject("adodb.recordset")

sql="select * from menu where id1="&id&" order by url,id"

rs.open sql,conn,1,1

if rs.recordcount=0 then

rs.close

set rs=nothing

exit function

end if

response.write("<table border=0 cellspacing=0 cellpadding=0>")

i=1

while not rs.eof

if len(rs("url"))>0 then

if i=rs.recordcount then

menutype="file1"

else

menutype="file"

end if

menuname="<a href="&rs("url")&" target=_blank>"&rs("menuname")&"</a>"

onmouseup=""

else

if i=rs.recordcount then

menutype="menu3"

listtype="list1"

onmouseup="with(eval(id"&rs("id")&"))if(style.display==){style.display=none;this.classname=menu3;}else{style.display=;this.classname=menu4;}"

else

menutype="menu1"

listtype="list"

onmouseup="with(eval(id"&rs("id")&"))if(style.display==){style.display=none;this.classname=menu1;}else{style.display=;this.classname=menu2;}"

end if

menuname=rs("menuname")

end if

%>

<tr>

<td class="<%= menutype%>" onmouseup="<%= onmouseup%>"><%= menuname%></td>

</tr>

<%if len(rs("url"))<3 then%>

<tr id="id<%= rs("id")%>" style="display:none">

<td class="<%= listtype%>"><%menu(rs("id"))%></td>

</tr>

<%

end if

rs.movenext

i=i+1

wend

response.write("</table>")

rs.close

set rs=nothing

end function

%>

<html>

<head>

<meta http-equiv="content-type" content="text/html; charset=gb2312">

<title>=========无限级目录树=========http://bbs.asp2004.net</title>

<style type="text/css">

<!–

.menu1 {

background-image: url(folder1.gif);

background-repeat: no-repeat;

height: 17px;

left: 32px;

padding-left: 32px;

cursor: hand;

}

.menu2 {

background-image: url(folder2.gif);

background-repeat: no-repeat;

height: 17px;

left: 32px;

padding-left: 32px;

cursor: hand;

}

.menu3 {

background-image: url(folder3.gif);

background-repeat: no-repeat;

height: 17px;

left: 32px;

padding-left: 32px;

cursor: hand;

}

.menu4 {

background-image: url(folder4.gif);

background-repeat: no-repeat;

height: 17px;

left: 32px;

padding-left: 32px;

cursor: hand;

}

.list {

padding-left: 20px;

background-image: url(list.gif);

background-repeat: repeat-y;

}

.list1 {

padding-left: 20px;

}

.file {

background-image: url(file.gif);

background-repeat: no-repeat;

height: 16px;

cursor: hand;

padding-left: 32px;

}

.file1 {

background-image: url(file1.gif);

background-repeat: no-repeat;

height: 16px;

cursor: hand;

padding-left: 32px;

}

body {

font-size: 9pt;

color: #000000;

background-color: #ffffff;

}

a:link {

font-size: 9pt;

color: #000000;

text-decoration: none;

}

a:visited {

font-size: 9pt;

color: #000000;

text-decoration: none;

}

a:hover {

font-size: 9pt;

color: #0000ff;

text-decoration: none;

position: relative;

right: 1px;

bottom: 1px;

}

a:active {

font-size: 9pt;

color: #000000;

text-decoration: none;

}

–>

</style>

<meta name="keywords" content="asp2004,树,菜单,无限级">

<meta name="author" content="小灰,quxiaohui_0@163.com">

</head>

<body>

<a href="http://bbs.asp2004.net/" target="_blank">http://bbs.asp2004.net/</a>提供最新下载《<a href="menu.asp">管理</a>》<br>

<%

menu 0

conn.close

set conn=nothing

%>

</body>

</html>

赞(0)
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com 特别注意:本站所有转载文章言论不代表本站观点! 本站所提供的图片等素材,版权归原作者所有,如需使用,请与原作者联系。未经允许不得转载:IDC资讯中心 » 利用C#在SQL Server2000存取图像 For Window-ASP教程,ASP应用
分享到: 更多 (0)