关于数据库与XML的问题

create table area
(
area_id int identity(1,1) not null,
area_name varchar(8) not null,
constraint pk_area primary key nonclustered (area_id)
)
insert into area (area_name) values ('华北地区')
insert into area (area_name) values ('华东地区')

create table province
(
province_id int identity(1,1) not null,
province_name varchar(6) not null,
area_id int not null,
constraint pk_province primary key nonclustered (province_id),
constraint fk_province_area foreign key (area_id) references area (area_id)
)
insert into province (province_name,area_id) values('北京',1)
insert into province (province_name,area_id) values('天津',1)
insert into province (province_name,area_id) values('河北',1)
insert into pr

这样做应该可以。

string sql="select area_id，area_name from area";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, "area");
sql="select province_name，province_id，area_id from province";
adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, "province");

foreach(DataRow row in resultDS.Talbes["area"].Rows)
{
string filter="area_id='"+row["area_id"].ToString()+"'";
TreeNode tn = new TreeNode();
tn.Name = row["area_id"].ToString();
tn.Text = row["area_name"].ToString();
treeView1.Nodes.Add(tn);
foreach(DataRow subrow in resultDS.Talbes["province"].select(filter))
{
TreeNode subtn = new TreeNode();
subtn.Name = subrow["province_id"].ToString();
subtn.Text = subrow["province_name"].ToString();
tn.Nodes.Add(subtn);