I have a piece of code like what is below. I have also looked it up around the web and it seems people are doing it the same way. I am curious why it will not compile and shows as an error.
Dim tempRow As DataRow
tempRow = WeekExcelTable.Select("ID = '" & drv.Item("ID") & "' AND Num = '" & _
drv.Item("NR") & "'")