初次使用TreeView，遇到一点小问题，急！急！急！（100分，来者有分！）

[qiuji]

初次使用TreeView，遇到一点小问题，急！100分，来者有分！
1.谁有使用C#编写的关于TreeView的源程序，连接SQL Server
2.我把一个VB.net写的源程序改写成C#时，编译时VS.NET提示“test030127.ds”并不包含对“tables”的定义。
下面代码有错误（ds1为DataSet数据集）：
for(i=0;i<=ds1.tables(0).Rows.count-1;i++)
以及myTreeNode.Text=ds1.tables(0).rows(i).item(1);
3.TreeView控件是不是所有的浏览器都支持，有没有不支持的？

[qiuji]

代码如下：
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Microsoft.Web.UI.WebControls;

namespace test030127
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Data.SqlClient.SqlDataAdapter mycommand;
protected System.Data.SqlClient.SqlConnection conn;
protected Microsoft.Web.UI.WebControls.TreeView TreeView1;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
protected System.Data.SqlClient.SqlDataAdapter myCommand2;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand2;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand2;
protected System.Data.DataSet ds;

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string NodeText="-1";
mycommand.Fill(ds);
int i;
for(i=0;i<=ds.tables(0).Rows.count-1;i++)
{
TreeNode myTreeNode=new TreeNode();
myTreeNode.Text=ds1.tables(0).rows(i).item(1);
myTreeNode.ImageUrl="images/openfolder.gif";
myTreeNode.ExpandedImageUrl="images/openfolder.gif";
TreeView1.Nodes.Add(myTreeNode);
CreateChildTree(myTreeNode,ds.tables(0).rows(i).item(0),ds.tables(0).rows(i).item(1));
}
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.mycommand = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.conn = new System.Data.SqlClient.SqlConnection();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.myCommand2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
//
// mycommand
//
this.mycommand.InsertCommand = this.sqlInsertCommand1;
this.mycommand.SelectCommand = this.sqlSelectCommand1;
this.mycommand.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "TREE", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NodeNumber", "NodeNumber"),
new System.Data.Common.DataColumnMapping("NodeName", "NodeName"),
new System.Data.Common.DataColumnMapping("TreeNode", "TreeNode")})});
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO TREE(NodeNumber, NodeName, TreeNode) VALUES (@NodeNumber, @NodeName, " +
"@TreeNode); SELECT NodeNumber, NodeName, TreeNode FROM TREE ORDER BY NodeNumber";
this.sqlInsertCommand1.Connection = this.conn;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NodeNumber", System.Data.SqlDbType.Int, 4, "NodeNumber"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NodeName", System.Data.SqlDbType.NVarChar, 50, "NodeName"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TreeNode", System.Data.SqlDbType.NVarChar, 50, "TreeNode"));
//
// conn
//
this.conn.ConnectionString = "data source=qiuji;initial catalog=testtree;integrated security=SSPI;persist secur" +
"ity info=False;workstation id=QIUJI;packet size=4096";
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT NodeNumber, NodeName, TreeNode FROM TREE WHERE (TreeNode = \'\"+NodeText+\"\')" +
" ORDER BY NodeNumber";
this.sqlSelectCommand1.Connection = this.conn;
//
// myCommand2
//
this.myCommand2.InsertCommand = this.sqlInsertCommand2;
this.myCommand2.SelectCommand = this.sqlSelectCommand2;
this.myCommand2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "TREE", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NodeNumber", "NodeNumber"),
new System.Data.Common.DataColumnMapping("NodeName", "NodeName"),
new System.Data.Common.DataColumnMapping("TreeNode", "TreeNode")})});
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO TREE(NodeNumber, NodeName, TreeNode) VALUES (@NodeNumber, @NodeName, " +
"@TreeNode); SELECT NodeNumber, NodeName, TreeNode FROM TREE ORDER BY NodeNumber " +
"DESC";
this.sqlInsertCommand2.Connection = this.conn;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NodeNumber", System.Data.SqlDbType.Int, 4, "NodeNumber"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NodeName", System.Data.SqlDbType.NVarChar, 50, "NodeName"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TreeNode", System.Data.SqlDbType.NVarChar, 50, "TreeNode"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT NodeNumber, NodeName, TreeNode FROM TREE WHERE (TreeNode = \'\"+NodeId+\"\') O" +
"RDER BY NodeNumber DESC";
this.sqlSelectCommand2.Connection = this.conn;
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

public void CreateChildTree(TreeNode ParentNode,string NodeId,string ParentNodeText)
{
myCommand2.Fill(ds);
int i;
for(i=0;i<=ds.tables(0).Rows.count-1;i++)
{
TreeNode myTreeNode2=new TreeNode();
myTreeNode2.Text=ds1.tables(0).rows(i).item(1);
myTreeNode2.ImageUrl="images/book.gif";
string myTreeNodeText=myTreeNode2.Text;
string ParentNodeTextS=ParentNodeText;
myTreeNodeText=Server.UrlEncode(myTreeNodeText);
ParentNodeTextS=Server.UrlEncode(ParentNodeTextS);
myTreeNode2.NavigateUrl="TarGet_Url.aspx?NodeText="+myTreeNodeText+"&ParentNodeText="+ParentNodeTextS;
myTreeNode2.Target="mainFrame";
ParentNode.Nodes.Add(myTreeNode2);
}
}
}
}

[tangjun]

我就用了Treeview
http://www.hntbtc.com/rsgl/rsgl.aspx
源程序；
http://www.hntbtc.com/rsgl/rsgl.rar

[flystar2]

change
for(i=0;i<=ds1.tables(0).Rows.count-1;i++)
to
for(i=0;i<=ds1.tables[0].Rows.count-1;i++)

[cooldht]

你搜索一下TreeView又很多文章的！

[henryfan1]

主意大小写。

[xiaomaoxia]

搜索一下一大把！！！！

[ykn]

搜索一下一大把！！！！

[smiletosky]

好象只有6.0支持

[smiletosky]

ds1，这个有问题吧，你把代码贴出来

[bwx]

调试一下问题会很快解决的

[bwx]

你指的浏览器是不是除ＩＥ之外的
那不一定都支持

[findawork]

up
支持

[追梦]

Browser: Version: IE5.5 or later

[findawork]

up
学习！
支持！

[tigerwuasp]

myTreeNode.Text=ds1.tables(0).rows[i][1];

[luhanzhang]

6.0以上的IE对TreeView支持很好，6.0以下经常会出现问题。