How to use select with Data table column name with special characters and variable

[Shan1986]

Hallo ,

I am facing a problem when using a column name with hyphen and also would like to know if i can use space in a column name.

following code works fine when the name of the column does not contain any spaces or hyphen. how do i use it for the column name with space or hyphen.

this is a small function and ColName is a string variable .

Dim findRows() As DataRow = DT.[Select](ColName & "=" & "'" & Value2Find & "'")

For Each row As DataRow In findRows
row.Item(ColName) = Value2Change
Next
Thanks.

Continue reading...