Dec 13, 2007

get the error System.__ComObject

I get the error System.__ComObject when using recordset?

This error occurs if you are trying to fetch the recordset value as follows

rs.Fields("productname")

To avoid this error try

VB.NET

rs.Fields("productname").Value.ToString()

C#

rs.Fields["productname").Value.ToString() ;