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
Use get row item activity
1 Like
Hi @suruchi120294,
-
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 activitylstColValue= internalSourceTable.Rows.Cast(Of DataRow)().Select(Function(a) a.Field(Of String)(“ColumnName”)).ToList()
Regards
Balamurugan.S
1 Like