public void LoadSourceDataSet()
{
int i = 0;
DataSet dsTemp = new DataSet();
DsSource = new DataSet();
IDbDataParameter[] sqlParam;
//Load Parameter value
SetSQLParametersValue();
//
foreach (RDLTable rtTable in DsReport.Tables)
{
sqlParam = new IDbDataParameter[rtTable.Parameters.Count];
i = 0;
foreach (RDLParameter param in rtTable.Parameters)
{
sqlParam[i] = new SqlParameter
{
ParameterName = param.Name,
DbType = param.DbType,
Value = param.Value
};
i++;
}
dsTemp = _reportSuiteRepository.LoadReportSourceDataSet(rtTable.CommandType, rtTable.CommandText, sqlParam);
dsTemp.Tables[0].TableName = rtTable.TableName;
DsSource.Tables.Add(dsTemp.Tables[rtTable.TableName].Copy());
}
}
