如何将C#逗号分隔值字符串转换为列表? [英] How to convert a c# comma separated values string into a list?
问题描述
我正在使用C#ASP.NET 4和SQL Server 2008 R2
I'm using C# ASP.NET 4 and SQL Server 2008 R2
我正在从sql server获得对象标量,该对象标量是一个字符串,其中包含逗号分隔的形式的值:
I'm getting an object scalar from sql server which is a string containing comma separated values of the form:
7,12,... 1,65
我想将此对象转换为列表吗?
I would like to convert this object into a list?
我想到了这个方向:
List< int>myList =新列表< int>(新int [](列表)mySqlClass.mySqlQueryReturningAnObject("SELECT CLAUSE");
但这是行不通的.
如何将该对象转换为列表?
How do I convert this object into a list?
此答案正在使用中(根据更新之前的答案)
This answer in use is according to the selected answer (before the update)
List< int>myList = new List< int>(mySqlClass.mySqlQueryReturningAnObject("SELECT CLAUSE").ToString().Split(',').Select(x => Convert.ToInt32(x)).ToList()); 代码>
推荐答案
var intValues = line.Split(',').Select(x => Convert.ToInt32(x)).ToList();
更新
要确保您的代码能够处理 1,2,3 ,,, 4,5,6
之类的字符串,可以使用 String.Split
方法的重载
To ensure your code would be able to process strings like 1,2,3,,,4,5,6
you can use overload of String.Split
method
var intValues = line.Split(new[] {','}, StringSplitOptions.RemoveEmptyEntries)
.Select(x => Convert.ToInt32(x))
.ToList();
这篇关于如何将C#逗号分隔值字符串转换为列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!