How to Read column from a csv file?

[suruchi120294 (Suruchi Kangutkar)]

how to read column from a csv file an display the column values in dropdpwn list ?
i am getting an error as “system.data.datarow cannot be converted to string”
help me out with this

[bala_subramanyam (Balu Vasireddy)]

Use get row item activity

Get Row Item

[balupad14 (Balamurugan)]

Hi @suruchi120294,

1. Use the Read Csv Activity and load the data into a datatable(dtCsv).
   2.Create the variable with type List. like “lstColValue”
   3.Use the assign activity

   lstColValue= internalSourceTable.Rows.Cast(Of DataRow)().Select(Function(a) a.Field(Of String)(“ColumnName”)).ToList()

Regards
Balamurugan.S