查询语句 select 字段1 as field from 表1 union select 字段2 as field from 表1 union select 字段3 as field from 表1 注意 3个字段需要相同的SQL类型 如果数据类型不同 使用convert函数转换 select convert(varchar(50),字段1) as field from 表1 union select convert(varchar(50),字段1) as field from 表1 union select convert(varchar(50),字段1) as field from 表1 返回的结果集的字段名为field
可以用xml从数据库中读出来,在填充到dropdownlist!.
select (airport_4code+"-"+airport_3code+"-"+chinese_name ) as myinfor from youtable drp0.DataTextField="myinfor "
select (airport_4code+'-'+airport_3code+'-'+chinese_name ) as myinfor from youtable 然后drp0.DataTextField="myinfor "
改变SQL语句即可, 如: SELECT airport_4code+ '-' + airport_3code + '-' + chinese_name AS unitname FROM youtable 绑定时指定第一个字段即可:unitname
那就是用convert函数转换 SELECT convert(varchar(500),airport_4code)+ '-' + convert(varchar(500),airport_3code) + '-' + convert(varchar(500),chinese_name) AS unitname FROM youtable
将它门放在 dataset 中
遍历 dataset
string kk=dataset.tables[0].rows[i][0]+dataset.tables[0].rows[i][1]+dataset.tables[0].rows[i][2];
在dataset中新建一列 将kk的值插入这列中,
榜定这个新列就可以了
{
DataTable objTable=DataSet.Table[0];DataTable objMyTable=new DataTable();
objMyTable.Columns.Add(new DataColumn("A",System.Type.GetType("System.String")));
DataRow objRow;for(int i=0;i<objTable.Rows.Count;i++)
{
objRow=objMyTable.NewRow();
objRow["A"]=objTable.Rows[i]["airport_4code"].ToString()+objTable.Rows[i]["airport_3code"].ToString()+objTable.Rows[i]["chinese_name"].ToString();objTable.Rows.Add(objRow);
}
objTable.AcceptChanges();
return objTable;
}将BB表做为数据源绑向dropdownlist,DataTextField="A";
select 字段1 as field from 表1
union
select 字段2 as field from 表1
union
select 字段3 as field from 表1
注意 3个字段需要相同的SQL类型
如果数据类型不同 使用convert函数转换
select convert(varchar(50),字段1) as field from 表1
union
select convert(varchar(50),字段1) as field from 表1
union
select convert(varchar(50),字段1) as field from 表1
返回的结果集的字段名为field
如:
SELECT airport_4code+ '-' + airport_3code + '-' + chinese_name AS unitname
FROM youtable
绑定时指定第一个字段即可:unitname
SELECT convert(varchar(500),airport_4code)+ '-' + convert(varchar(500),airport_3code) + '-' + convert(varchar(500),chinese_name) AS unitname
FROM youtable