直接上代码:
sPathCollection = String.Join(",",dt_ProposalInfo.Rows.Cast(Of System.Data.DataRow).Where(Function(r) r("Function").ToString = "Save Path" ).Select(Function(r) r("Folder Path").ToString))
假设dt有一列标题为Function,Folder Path
我们想获得这个Sheet "Save Path"的值,即对应Folder Path的值,并用","隔开:"This is Save Path A,This is Save Path B"
那么我们用上面LINQ表达式