Split data table column into an Array

Question

I have a Data Table named as dt .The Table contains the following. Name bike name Rate Ram A 20 Sri B 10 dina C 40 Ram D 50 Sri E 60 dina F 70 Ram S 80 Sri Q 65 dina L 70 Sonu B 30 Now I want to split the Table column Name and extract the names from that data column to string Array[]. O/p: string[]arr={RamSridina} .I don't know how to solve this problem.Help me to solve this.

Mangesh Gaherwar · Answer

Try this string[] Name = table.AsEnumerable().Select(r => r.Field (Name)).Distinct().ToArray(); Mark approved if it Helps

Dinesh Santhalingam · Answer

Thanks alot @ Mangesh Gaherwar

Rajeev Punhani · Answer

Hi Dinesh Please see the below link. https://dotnetfiddle.net/61TN7m If the above solution is helpful then accept the answer.

Dinesh Santhalingam · Answer

In this method the names loading repeatively. string[] Name=[RamSridinaRamSridinaRamSriSonu]; But I want Sting Name=[ RamSridinaSonu ] like this. @mangesh

Mangesh Gaherwar · Answer

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

Bikesh Srivastava · Answer

just use foreach loop on dt and get column value and store in array.

Name	bike name	Rate
Ram	A	20
Sri	B	10
dina	C	40
Ram	D	50
Sri	E	60
dina	F	70
Ram	S	80
Sri	Q	65
dina	L	70
Sonu	B	30