2008-01-21 11:23:14 AfritXia()
rs["hint"] is DBNull
2008-01-21 11:24:23 安安()
DBNull 代表该字段为空?谢谢了
2008-01-21 11:24:26 安安()
我试一下
2008-01-21 11:24:57 安安()
后面哪里是什么意思node &"hint:"& reg.replace(rs("hint"), chr(15)) &";"
2008-01-21 11:25:34 安安()
Afr,有看过梅花雪树吗?我就是想用asp.net实现
2008-01-21 11:25:55 AfritXia()
[表情] 没有
2008-01-21 11:26:09 AfritXia()
不是有很多现成的 树形控件么?
2008-01-21 11:26:25 安安()
if rs("hint")<>"" then node = node &"hint:"& reg.replace(rs("hint"), chr(15)) &";"
2008-01-21 11:26:53 安安()
是现成的哦,但要调用数据库的数据进去
2008-01-21 11:27:38 安安()
梅花雪树是JS的,这一例子是这样的
<%@ Language=VBScript codepage=936 %>
<% Option Explicit %>
<%
Dim Conn, rs
Set Conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& Server.MapPath("./") &"\tree.mdb;"
rs.open "Select ID, parentId, text, hint, icon, data, url, target, method From treeview order by ID", Conn
%>
<html>
<head>
<title>梅花雪中文网 - 网页脚本控件集 MzTreeView10</title>
<meta http-equiv="Content-Type" c>
<meta name="author" c>
<script language="JavaScript" src="MzTreeView10.js"></script>
<link href="
http://www.meizz.com/Scripts/Global.css" type="text/css" rel="stylesheet">
<style>
A.MzTreeview
{
font-size: 9pt;
padding-left: 3px;
}
</style>
</head>
<body class=frame>
<SCRIPT LANGUAGE="JavaScript">
<!--
window.tree = new MzTreeView("tree");
tree.icons["property"] = "property.gif";
tree.icons["css"] = "collection.gif";
tree.icons["book"] = "book.gif";
tree.iconsExpand["book"] = "bookopen.gif"; //展开时对应的图片
tree.setIconPath("
http://www.meizz.com/Icons/TreeView/"); //可用相对路径
<%
Dim node
Dim reg : set reg = new RegExp : reg.global=True : reg.pattern=";"
Dim id, parentId, text, hint, icon, data, url, target, method
do while not rs.eof
'若是树的条目比较多的时候(比如大于1000)而又相对稳定的时候将这些数据生成静态网页来访问
node = VBCrLf &" tree.nodes["""& rs("parentId") &"_"& rs("id") &"""] = """
node = node &"text:"& reg.replace(rs("text"), chr(15)) &";"
if rs("hint")<>"" then node = node &"hint:"& reg.replace(rs("hint"), chr(15)) &";"
if rs("icon")<>"" then node = node &"icon:"& rs("icon") &";"
if rs("data")<>"" then node = node &"data:"& reg.replace(rs("data"), chr(15)) &";"
if rs("url")<>"" then node = node &"url:"& reg.replace(rs("url"), chr(15)) &";"
if rs("target")<>"" then node = node &"target:"& rs("target") &";"
if rs("method")<>"" then node = node &"method:"& reg.replace(rs("method"), chr(15)) &";"
response.write node &"""" '生成节点信息
rs.movenext
loop
%>
tree.setURL("Catalog.asp");
tree.setTarget("MzMain");
document.write(tree.toString()); //亦可用 obj.innerHTML = tree.toString();
//-->
</SCRIPT>
</body>
<[表情]ml>
<%
rs.close : set rs = nothing : Conn.close : set Conn = nothing
%>
2008-01-21 11:28:11 AfritXia()
唉,asp.net 控件,要是这么写,会很麻烦的
2008-01-21 11:29:06 AfritXia()
你只是把 <% %> 里面的内容改成 asp.net 的了?
2008-01-21 11:29:07 安安()
中间这里是调用,我要转成asp.net的
2008-01-21 11:29:12 安安()
对哦
2008-01-21 11:29:22 安安()
我就是改<%%>的内容
2008-01-21 11:29:27 安安()
但老提示出错
2008-01-21 11:29:34 AfritXia()
出什么错?
2008-01-21 11:29:53 安安()
就是if rs("data")<>"" 不知用C#如何写
2008-01-21 11:30:17 AfritXia()
if (rs["data"] != "")
2008-01-21 11:30:20 安安()
你说的asp.net的控件指的是treeview吧?