I am using a classic ADO recordset in a C# Winforms application. The recordset is created by a VB6 COM+ component and assigned to a recordset variable declared as an ADODB.Recordset type. I am able to instantiate the variable in my C# function and assign the COM+ recordset to the C# recordset; but, I'm having trouble assigning values to the ADO fields using ADO syntax. I'm getting abuild error that states "'ADODB.Recordset' does not contain a definition for 'Fields_Recordset'".

Here's the code I'm using:

// Declare the ADO recordset used in the calling functioon
ADODB.Recordset rs = new ADODB.Recordset();

// Declare and instantiate the COM+ object
Grading.clsGrading gr = new Grading.clsGrading();

// Assign the COM+ ADO recordset to the calling recordset
rs = gr.CreateInput();

//Assign field value
rs.Fields("LoanNbr") = "1003";

Thanks in advance for any assistance provided.

Greg

After palying around with my code some more, I found my mistake(s). First, I had to add a using statement for ADODB. Second, I had to use square brakets for the field identifiers and use the .Value to correctly assign the value. The new code looks like this:

using ADODB;

ADODB.Recordset rs = new ADODB.Recordset();

Grading.clsGrading gr = new Grading.clsGrading();

rs = gr.CreateInput();

rs.Fields["LoanNbr"].Value = "1003";