John Papas has an interesting article on the topic in the current issue of MSDN Magazine, Migrating from ADO to ADO.NET . His approach is pretty straight-forward - "Here's x in ADO, here's what it has become in ADO.NET, here are the differences...
Yesterday, I needed to filter an ADO Recordset field by multiple values, so I first tried: 'myFilterList = "1,3,4,5" If myFilterList & vbNullString <> vbNullString Then MyRecordset.Filter = "MyField IN (" & myFilterList...