How select on column in datatable and assign it to datarow array

[moha_attia (mohamed)]

[lakshman (Ganta lakshman)]

@moha_attia,

Try this one:
Datatablename.select(“ColumnName = value”)

[pavanh003 (Pavan Harisha)]

Hi,

Please try this arrayDrValue=datatable.Select(“[ColumnName] = ‘Value’”) This will return you array of datarow,
arrayDrValue = array of data row

Please let us know if this helps.

Regards,
Pavan H

[suruchi120294 (Suruchi Kangutkar)]

Hi,
try this.

Regard’s,
Suruchi.

[moha_attia (mohamed)]

thanks all for reply i now it but i need all data in City Column not just ‘Mumbai’

[Susana (Susana González Cacheiro)]

Hello @moha_attia,

Hope this could help you, the following link os for a similar problem:

How insert whole column into one row with Pipe delimiter? Have two DataTables

Hi I need help Have two separate DataTables: DataTables1 contains one column with 3 to 9 URL`s, DataTables2 contains several columns and one of them is named “URL” Want insert into one row with Pipe delimiter whole rows of DataTables1 in to DataTables2 column named “URL” DataTable1 [DataTable1] DataTable2 [DataTable2] Regards Tomas

You can use something similar to ExtractDataTable.AsEnumerable.Select(Function(row) row(“City”).ToString)

Best regards,
Susana

[moha_attia (mohamed)]

thanks all ,