/// <summary>
/// 把DataTable的某一列转化为逗号分隔字符串
/// </summary>
/// <param name="dataTable">dataTable</param>
/// <param name="strColumn">列</param>
/// <param name="type">type</param>
/// <returns>返回结果</returns>
public string DataTableColumnSplit(DataTable dataTable, string strColumn, string type)
{
Type dataType = dataTable.Columns[strColumn].DataType;
if (dataType.Name == "String")
{
string[] idIn = dataTable.AsEnumerable().Select(r => r.Field<string>(strColumn)).ToArray();
return string.Join(type, idIn);
}
else if (dataType.Name == "Int32")
{
int[] idIn = dataTable.AsEnumerable().Select(d => d.Field<int>(strColumn)).ToArray();
return string.Join(type, idIn);
}
return null;
}
把DataTable的某一列转化为逗号分隔字符串
最新推荐文章于 2023-07-24 20:12:30 发布