We almost succeeded at sending parameters. No errors is being thrown. But no result is being returned from stored procedure. In order to debug, we Run Profiler, to see upcoming sql commands. There, we san that empty params are being sent to sql server. I have attached screenshot. We are doing everything from code purely, nothing depends on from designer file (in terms of data source). HERE is our code.
Code: Select all
var dataSource = (StiSqlSource)report.DataSources[0];
// Set new query
dataSource.SqlCommand = "sp_TL_Rep_PayPeriod";// query;
dataSource.Type = StiSqlSourceType.StoredProcedure;
var rParams = new StiDataParametersCollection();
var pFromDate = new StiDataParameter("@pFromDate", (int)SqlDbType.DateTime, 0);
pFromDate.ParameterValue = parameters.Date.ToSqlValue();
rParams.Add(pFromDate);
var pToDate = new StiDataParameter("@pToDate", (int)SqlDbType.DateTime, 0);
pToDate.ParameterValue = parameters.Date.ToSqlValue();
rParams.Add(pToDate);
var pFromGroup = new StiDataParameter("@pFromGroup", (int)SqlDbType.NVarChar,10);
pFromGroup.ParameterValue = parameters.EmployeeGroupFrom;
rParams.Add(pFromGroup);
var pToGroup = new StiDataParameter("@pToGroup", (int)SqlDbType.NVarChar, 10);
pToGroup.ParameterValue = parameters.EmployeeGroupTo;
rParams.Add(pToGroup);
var pFromAgree = new StiDataParameter("@pFromAgree", (int)SqlDbType.NVarChar,8);
pFromAgree.ParameterValue = parameters.AgreeFrom;
rParams.Add(pFromAgree);
var pToAgree = new StiDataParameter("@pToAgree", (int)SqlDbType.NVarChar, 8);
pToAgree.ParameterValue = parameters.AgreeTo;
rParams.Add(pToAgree);
var inOrder = new StiDataParameter("@inOrder", (int)SqlDbType.NVarChar, 200);
inOrder.ParameterValue = parameters.InOrder;
rParams.Add(inOrder);
var pBreakOrder = new StiDataParameter("@BreakOrder", (int)SqlDbType.SmallInt, 0);
pBreakOrder.ParameterValue = (parameters.PageBreak == 2).ToSqlValue();
rParams.Add(pBreakOrder);
var pGetDataFrom = new StiDataParameter("@pGetDataFrom", (int)SqlDbType.SmallInt, 0);
pGetDataFrom.ParameterValue = parameters.GetDataFrom;
rParams.Add(pGetDataFrom);
var pPeriodType = new StiDataParameter("@pPeriodType", (int)SqlDbType.SmallInt, 0);
pPeriodType.ParameterValue = parameters.PeriodType;
rParams.Add(pPeriodType);
var pActive = new StiDataParameter("@pActive", (int)SqlDbType.SmallInt, 0);
pActive.ParameterValue = parameters.Active.ToSqlValue();
rParams.Add(pActive);
var pxByParm = new StiDataParameter("@xByParm", (int)SqlDbType.VarChar, 3);
pxByParm.ParameterValue = parameters.ByParam;
rParams.Add(pxByParm);
var pxEmpDepList = new StiDataParameter("@xEmpDepList", (int)SqlDbType.VarChar, 50);
pxEmpDepList.ParameterValue = parameters.EmployeeDepartmentList;
rParams.Add(pxEmpDepList);
var pinSelect = new StiDataParameter("@inSelect", (int)SqlDbType.VarChar, -1);
pinSelect.ParameterValue = "";
rParams.Add(pinSelect);
dataSource.UpdateParameters();
dataSource.Parameters = rParams;
Can you please clarify what error is occuring here and what can be done about it?
Regards,
Iskandar