I have been trying to use ADO in C#, which I am familar with in VB6.
When I try and use the Execute method of the Connection (Connection.Execute) it requires parameters. (string commandtext, out RecordsAffected, int Options).
I am trying to use:
ADODB.Connection mcnn; //This is setup and connected in another function - just here to show declare
rs = mcnn.Execute(sSQL);
The other parameters used to be optional but when I try and compile it says "No Overload method for method "Execute" takes 1 arguments"
At first I thought I was using ADO.Net, so I unferenced ADODB and selected ADO 2.6 from the COM tab of the references, but it still happens. There is probably some simple answer for what I am doing wrong here but I can't find it.