public static string GetQueryString(PivotGridControl pivot, string fullConnectionString, bool nonEmptyBehavior)
{
OLAPConnectionStringBuilder builder = new OLAPConnectionStringBuilder(fullConnectionString);
string cubeName = builder.CubeName;
return(_select + GetNonEmptyString(nonEmptyBehavior) + GetMeasuresString(pivot) + _onColumns + _parametersSeparator + GetNonEmptyString(nonEmptyBehavior) + GetDimensionsString(pivot) + _onRows + _from + SquareBrackets(cubeName));
}
public CubeToTableAdapter(PivotGridControl pivot)
{
this.pivot = pivot;
if (pivot.IsOLAPDataSource)
{
fullConnectionString = pivot.OLAPConnectionString;
OLAPConnectionStringBuilder builder = new OLAPConnectionStringBuilder(fullConnectionString);
providerConnectionString = builder.ConnectionString;
}
else
{
fullConnectionString = string.Empty;
providerConnectionString = string.Empty;
}
}
