根据用户需求和网页设计的排版.只需要一个TextBox,但要查询表中的两个字段.下面提出了解决的办法:
create table a
(
id [int] IDENTITY (1, 1) NOT NULL ,
CName varchar(20),
Enname varchar(30)
)
insert into a(cname,Enname) values('张','zhang')
insert into a(cname,Enname) values('张123','a23zhang')
insert into a(cname,Enname) values('3456张','b2345zhang')
insert into a(cname,Enname) values('2345张','czhang')
方法1:
select a.cname from a a where Cname='张' union select b.enname from a b where ENName='张'
方法2:
if exists (select a.cname from a where a.CName='zhang')
select a.cname from a where a.CName='zhang'
else
select b.EnName from a b where b.EnName='zhang'
方法3(这种方法在里没有实际意义,只提供一条思路)
declare @Temp table(id int identity(1,1),name varchar(20))
insert into @Temp(Name) select a.cname as Name from a a where Cname='张' union select b.enname as Name from a b where ENName='张'
select Name from @Temp