110,545
社区成员
发帖
与我相关
我的任务
分享
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=abc.mdb";
。。。
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
string OleDb = "select * from tTableEasy where fid=1";
OleDbCommand cmd = new OleDbCommand(OleDb, conn);
try
{
conn.Open();
OleDbDataReader reader=cmd.ExecuteReader();
TreeNode node = new TreeNode(reader["fName"].ToString());
node.Tag = reader["fLevel"].ToString();
node.Name = reader["fid"].ToString();
treeView1.Nodes.Add(node.Name);//把以上节点加入到根节点
List<TreeNode> A=new List<TreeNode>();
cmd.CommandText = "select * from tTableEasy where fLevel = " + 1 + " and fParentid = " + node.Name;
cmd.Connection = conn;
OleDbDataReader reader1 = cmd.ExecuteReader();
A.Add(new TreeNode(reader1["fName"].ToString()));
//遍历生成所有树
while (reader.Read())
{
foreach (TreeNode node1 in A)
{
cmd.CommandText = "select * from tTableEasy where fLevel = " +(node1.Level+1) + " and fParentid = " + node1.Name;
cmd.Connection = conn;
TreeNode NewNode = new TreeNode(reader1["fName"].ToString());
node1.Nodes.Add(NewNode);
node.Nodes.Add(node1);
}
}
reader.Close();
}
string OleDb = "select * from tTableEasy where fid=1";
OleDbCommand cmd = new OleDbCommand(OleDb, conn);
try
{
conn.Open();
OleDbDataReader reader=cmd.ExecuteReader();
TreeNode node = new TreeNode(reader["fName"].ToString());
node.Tag = reader["fLevel"].ToString();
node.Name = reader["fid"].ToString();
treeView1.Nodes.Add(node.Name);//把以上节点加入到根节点
protected void Page_Load(object sender, EventArgs e)
{
GetTable();
Bind_Tree(0, null);
}
public void Bind_Tree(int fid,TreeNode node)
{
DataTable dt = ViewState["Table"] as DataTable;
DataRow[] row = dt.Select("fParentid=" + fid + "");
foreach (DataRow r in row)
{
TreeNode n = new TreeNode(r["fname"].ToString(), r["fid"].ToString());
if (fid == 0)
TreeView1.Nodes.Add(n);
else
node.ChildNodes.Add(n);
Bind_Tree(Convert.ToInt32(r["fid"]), n);
}
}
public void GetTable()
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["daxueConnection"].ConnectionString;
conn.Open();
string strSql = "select fid,fname,fParentid from daxue";
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
ViewState["Table"] = dt;
}
}
conn.Open();
OleDbDataReader reader=cmd.ExecuteReader();
TreeNode node = new TreeNode(reader["fName"].ToString());
node.Tag = reader["fLevel"].ToString();
node.Name = reader["fid"].ToString();
treeView1.Nodes.Add(node.Name);//把以上节点加入到根节点