ADODB in c#

[kingstonr]

Folks,

In one of my requirement I have to use ADODB(since I need
old method recordset)in c#.I am trying to execute stored proc I don't know how to pass parameters from c# to adodb can anyone help me.

rs=cmd.execute(out object recordsaffected,ref object parameters,int options)

can somebody help me how to pass ref object parameters with some sample.

Thanks
kingston

 

[mjjks]

I'm not sure I understood you correctly, but why do you need older method ADODB? Only situation I can think of is if you have a DLL written in VB6 or something like that, and expects recordset as a parameter in a procedure/function.

In that case you probably can use unsecure method that should run in .NET:

Set rs = cmd.Execute("exec spStoredProcedurename " & intParam1 & ",'" & strParam2 & "'")