Our Training Programs

All contents are copyright of their authors.

Split data table column into an Array

Split data table column into an Array

Dinesh Santhalingam

9yAsked Jan 6, 2017, 7:26 AM1.1kVisual Basic .NET

I have a Data Table named as dt .The Table contains the following.,

Now I want to split the Table column "Name" and extract the names from that data column to string Array[].

O/p: string[]arr={"Ram","Sri","dina"} .I don't know how to solve this problem.Help me to solve this.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Mangesh G9y ago
Accepted answer
Try this

string[] Name = table.AsEnumerable().Select(r => r.Field("Name")).Distinct().ToArray();

Mark approved if it Helps
Dinesh Santhalingam9y ago
Thanks alot @
Mangesh Gaherwar
Rajeev Punhani9y ago
Hi Dinesh,

Please see the below link.

https://dotnetfiddle.net/61TN7m
If the above solution is helpful then,accept the answer.
Bikesh Srivastava9y ago
just use foreach loop on dt and get column value and store in array.
Dinesh Santhalingam9y ago
In this method the names loading repeatively.
string[] Name=["Ram","Sri","dina",Ram","Sri","dina",Ram","Sri","Sonu"];

But I want Sting Name=["Ram","Sri","dina","Sonu"] like this.

@mangesh
Mangesh G9y ago
Hi Dinesh

Try this On Ur code
string[] Namearr= table.AsEnumerable().Select(r => r.Field("Name")).ToArray();

Hope it Helps

Mark Approved if it does