Assign value from ADODB.Recordset

in VBA I assign variables with values retreived from a recordset like this:

variable1 = rs("column1")
variable2 = rs("column2")

Can I do the same in C开发者_C百科#?

ADODB has been deprecated for years. For data access in .NET, you should use ADO.NET (DbConnection, DbCommand, DbDataReader, DataSet, DataTable, DbDataAdapter...)

If you really must use ADODB, see this question on MSDN.