using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using ComponentArt.Web.UI;
public partial class treeView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = databing();
DataRow[] drs = dt.Select("Pranent=''");
foreach (DataRow dr in drs)
{
TreeViewNode tn = new TreeViewNode();
tn.Text = dr["partName"].ToString();
tn.Value = dr["Guid"].ToString();
showsData(tn.Value,tn,dt);
TreeView1.Nodes.Add(tn);
}
}
}
private DataTable databing()
{
string conStr = "server=.;pwd=qihuan;uid=sa;database=wish";
string sql = "select * from temp";
SqlConnection con = new SqlConnection(conStr);
SqlDataAdapter adpt = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
return dt;
}