CREATE TABLE area (
areaid INT IDENTITY NOT NULL,
areaname VARCHAR ( 50 ),
Fatherld INT,
CONSTRAINT PK_area PRIMARY KEY NONCLUSTERED (areaid)
)
insert into area(areaname ,Fatherld) values('root1',-1)
insert into area(areaname ,Fatherld) values('child1',1)
insert into area(areaname ,Fatherld) values('child2',1)
1、数据库SQL2.X 或ACCESS
2、要实现的内容:
1.1当点击getdata.aspx的 BUTTON获取数据是,弹出getdata.aspx的.
1.2当选定dtrees.aspx页面(本树是用dtree实现)的中的结点时,在getdata.aspx的
ID:
Areaname
显示内容所选取的areaname,areaid
(注意:用Ajax实现)
小弟在此感谢大家!
下面是两个页面代码(我不知道,怎么上传文件提问, 不好意思,晒码了.):
dtrees.aspx页面:
function gourl(id)
{
alert(id);
}
无标题页dtrees.aspx后台:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string jtree = "
jtree += "d = new dTree('d');\n";
DataTable dt = LinqToDataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
jtree += "d.add(" + dr[0] + "," + dr[2] + ",'" + dr[1] + "','javascript:gourl(" + dr[0] + ")');";
}
jtree += "document.write(d);";
jtree += "";
this.Label1.Text = jtree;
}
}
public System.Data.DataTable LinqToDataTable()
{
SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["constring"].ConnectionString.ToString());
SqlDataAdapter da = new SqlDataAdapter("select * from area order by areaid asc", conn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
getdata.aspx页面:
无标题页Areaname
getdata.aspx后台:
请自定义,,
如果实现或看不明白的,邮箱:chenxuebo03@163.com QQ45433621
联系!分数贴上!