--1 select 1 union all select 2--2 select m.* , n.* from (select 1) m , (select 2) n where m.关键字 = n.关键字
SqlDataCommand cmd=new SqlDataCommand (连接串); cmd.CommandText="select 1 union all select 2"; DataAdpater ad = new DataAdpater(); ad.SelectCommand= cmd; DataSet set= new DataSet(); ad.Fill(set) ;
union all
select 2
union
select 2定义一个Dateset 类型接收返回值就行了
select 1
union all
select 2--2
select m.* , n.*
from
(select 1) m ,
(select 2) n
where m.关键字 = n.关键字
cmd.CommandText="select 1 union all select 2";
DataAdpater ad = new DataAdpater();
ad.SelectCommand= cmd;
DataSet set= new DataSet();
ad.Fill(set) ;