T
TedL
Can anyone find anything wrong with this code? I don't get any
exceptions from it, but I don't get any data returned either! Any
help would be greatly appreciated--I've been working on this all
friggin' day! Thanks!
Ted
****************************
ADODB.Connection adoConn2 = new ADODB.ConnectionClass();
ADODB.Recordset adoRS = new ADODB.RecordsetClass();
ADODB.Command cmd = new ADODB.CommandClass();
ADODB.Parameter param = new ADODB.ParameterClass();
adoConn2.Open("PROVIDER=SQLOLEDB;INITIAL
CATALOG=pubs;SERVER=localhost;", "sa", "password", -1);
cmd.CommandText = "byroyalty";
cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc;
param = cmd.CreateParameter("percentage",
ADODB.DataTypeEnum.adInteger,
ADODB.ParameterDirectionEnum.adParamInput, 0, 100);
cmd.Parameters.Append(param);
object objRecs, objParameters = cmd.Parameters;
cmd.ActiveConnection = adoConn2;
adoRS = cmd.Execute(out objRecs, ref
objParameters,(int)ADODB.CommandTypeEnum.adCmdStoredProc);
******************************************
exceptions from it, but I don't get any data returned either! Any
help would be greatly appreciated--I've been working on this all
friggin' day! Thanks!
Ted
****************************
ADODB.Connection adoConn2 = new ADODB.ConnectionClass();
ADODB.Recordset adoRS = new ADODB.RecordsetClass();
ADODB.Command cmd = new ADODB.CommandClass();
ADODB.Parameter param = new ADODB.ParameterClass();
adoConn2.Open("PROVIDER=SQLOLEDB;INITIAL
CATALOG=pubs;SERVER=localhost;", "sa", "password", -1);
cmd.CommandText = "byroyalty";
cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc;
param = cmd.CreateParameter("percentage",
ADODB.DataTypeEnum.adInteger,
ADODB.ParameterDirectionEnum.adParamInput, 0, 100);
cmd.Parameters.Append(param);
object objRecs, objParameters = cmd.Parameters;
cmd.ActiveConnection = adoConn2;
adoRS = cmd.Execute(out objRecs, ref
objParameters,(int)ADODB.CommandTypeEnum.adCmdStoredProc);
******************************************