public object ResolveDataSet(RdlDataSet dataSetElement, bool adhoc)
{
var queryElement = dataSetElement.Query;
if (queryElement == null)
{
return(null);
}
var transactional = !adhoc && IsTransactional;
var command = (transactional ? TransactionConnection : AdHocConnection).CreateCommand();
command.CommandType = GetCommandType(queryElement.CommandType);
command.CommandText = queryElement.CommandText;
command.CommandTimeout = GetCommandTimeout(queryElement.Timeout);
command.Transaction = transactional ? Transaction : null;
foreach (var parameterElement in queryElement.QueryParameters)
{
var parameter = command.CreateParameter();
parameter.ParameterName = parameterElement.Name;
var value = LocalReportsEngineCommon.PhraseToValue(ReportMeta, RdlDataTypeEnum.String,
parameterElement.Value);
parameter.Value = value;
command.Parameters.Add(parameter);
}
using (var reader = command.ExecuteReader())
{
var dataTable = new DataTable();
dataTable.Load(reader);
return(dataTable);
}
}
public object ResolveDataSet(RdlDataSet dataSetElement, bool adhoc)
{
// Prompt the user first
if (dataSetElement.Query == null)
{
return(null);
}
return(DataSources[dataSetElement.Query.DataSourceName].ResolveDataSet(dataSetElement, adhoc));
}
public object ResolveDataSet(RdlDataSet dataSetElement, bool adhoc)
{
// Prompt the user first
if (dataSetElement.Query == null)
return null;
return DataSources[dataSetElement.Query.DataSourceName].ResolveDataSet(dataSetElement, adhoc);
}
