select * from gdi_graph
select * from gdi_node
---------------------------------
id color url
1 #CCCCCC http://www.baidu.com
2 #FFFFFF http://www.csdn.netid Xcood Ycood graphId
1 100 0 1
2 0 200 1
3 300 200 1
4 50 30 2
5 60 80 2
sql语句后
declare @tb table (id int , color varchar(15),url varchar(100), gid varchar(5))
declare @id int
set @id=1
while @id <= (select MAX(id) from gdi_graph )
begin
insert into @tb
select id,color,url,'' gid from gdi_graph where id=@id
union all
select a.id,ltrim(Xcood),ltrim(Ycood),ltrim(graphId )
from gdi_node a join (select id,color,url,'' gid
from gdi_graph where id=@id) b on a.graphId=b.id
set @id=@id+1
end
select * from @tb
----------------------------------------
id color url gid
1 #CCCCCC http://www.baidu.com
1 100 0 1
2 0 200 1
3 300 200 1
2 #OOOOOO http://www.google.com
4 50 30 2
5 60 80 2在c#中怎样循环,gid为1的循环完了,再循环gid为2的
select * from gdi_node
---------------------------------
id color url
1 #CCCCCC http://www.baidu.com
2 #FFFFFF http://www.csdn.netid Xcood Ycood graphId
1 100 0 1
2 0 200 1
3 300 200 1
4 50 30 2
5 60 80 2
sql语句后
declare @tb table (id int , color varchar(15),url varchar(100), gid varchar(5))
declare @id int
set @id=1
while @id <= (select MAX(id) from gdi_graph )
begin
insert into @tb
select id,color,url,'' gid from gdi_graph where id=@id
union all
select a.id,ltrim(Xcood),ltrim(Ycood),ltrim(graphId )
from gdi_node a join (select id,color,url,'' gid
from gdi_graph where id=@id) b on a.graphId=b.id
set @id=@id+1
end
select * from @tb
----------------------------------------
id color url gid
1 #CCCCCC http://www.baidu.com
1 100 0 1
2 0 200 1
3 300 200 1
2 #OOOOOO http://www.google.com
4 50 30 2
5 60 80 2在c#中怎样循环,gid为1的循环完了,再循环gid为2的
程序里直接循环,判断下gid是多少,该做什么直接写就好