Using ADOdb recordset inside of .Net

[MFRASER]

Does anyone have an example of how to use an ADOdb recordset inside of .Net?
I am trying to interface with a VB application that uses the ADOdb
recordset.

Here is my code:

ADODB.Recordset rst = new Recordset();

ADODB.Connection conn = new Connection();

ADODB.Command cmd = new Command();

object records = null;

object rstparams = null;

string sqlStatement = "";


conn.Open(gConnString,"","", 0);

cmd.ActiveConnection = conn;

cmd.CommandText = sqlStatement;

cmd.CommandType = ADODB.CommandTypeEnum.adCmdText;

cmd.Dialect = "{2BDA0E41-4A58-4721-BC09-6670511BC530}";

rst = cmd.Execute(out records, ref rstparams, 0);

 

[MFRASER]

I was able to get this to work using an object nullobj = Type.Missing in the
place of optional params.

 

[MFRASER]

I was able to get this to work using an object nullobj = Type.Missing in the
place of optional params.