代码中需要拿到多行为一行数据
- 我需要拿到一列DataTable除了id与SelectId的所有行
- dtFieldsID_BZ为一列多行的字段,列名为“name”
var list = dtFieldsID_BZ.Select("name<>'id' and name<>'SelectId'").Select(dr => dr["name"].ToString()).ToList();
var list2 = from x in dtFieldsID_BZ.AsEnumerable() where x[0].ToString() != "id" && x[0].ToString() != "SelectId" select x.Field<string>("name");
string res = string.Join(",", list2);
string FieldsID_BZ = string.Join(",", list.ToList());
我要直接需要用到一行数据(这一行数据由多行拼接)
- 突然联想到,我需要把一列数据按照,分割拼接起来的时候:
【1】 先alt +shift+光标把每个字段后面都加上,
【2】复制到Excel转置,concat拼接
【3】去掉最后一个符号
SQLServer多行转为1行
【1】表ShoppingCart,多行转一列
select name+',' from ShoppingCart for xml path('')
【2】给这个表命名
select distinct
(select name+',' from ShoppingCart for xml path(''))
as zz from ShoppingCart
【3】表的列名?
select COLUMN_NAME,ORDINAL_POSITION
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='ShoppingCart' order by ORDINAL_POSITION