DynamicListLookUpSettings.DataMember Property

Gets or sets a specific data member in a dashboard data source for a dashboard parameter.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v24.2.Core.dll

Declaration

C#

[DefaultValue(null)]
[LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)]
public string DataMember { get; set; }

VB.NET

<LocalizableCategory(DataAccessStringId.PropertyGridDataCategoryName)>
<DefaultValue(Nothing)>
Public Property DataMember As String

Property Value

Type	Default	Description
String	null	A String value that specifies a data member in a dashboard data source for a dashboard parameter.

Remarks

You can specify a data source as a source for dashboard parameter values. To provide access to data source values, specify the following options:

UI Settings	Description	API
Data Source	Specifies the data source for the dashboard parameter.	DataSource
Data Member	Specifies the name of the data member with the parameter values for SQL and Entity Framework data sources.	DataMember
Value Member	Specifies the name of the data field for the parameter values.	ValueMember
Display Member (optional)	Specifies the name of the data field displayed in the Dashboard Parameters dialog as a value description.	DisplayMember
Sort By (optional)	Specifies the data member used to sort parameter values.	SortByMember
Sort Order (optional)	Specifies the sort order.	SortOrder

Note

You cannot use an OLAP data source as the data source for a dashboard parameter.

The DataMember property is in effect for the DashboardSqlDataSource and DashboardEFDataSource only. For SQL data sources, the data member is a query used to select a specific subset of data. Use the SqlDataSource.Queries property to obtain the available data source queries. Then, assign the name of the query (SqlQuery.Name) to the DataMember property to bind the dashboard parameter values to this query.

The following code snippet shows how to create a dashboard parameter with dynamic look-up values in code. Use the Dashboard.Parameters property of Dashboard to access a collection of dashboard parameters.

C#

DynamicListLookUpSettings settings = new DynamicListLookUpSettings();
settings.DataSource = sqlDataSource;
settings.DataMember = "Categories";
settings.ValueMember = "CategoryID";
settings.DisplayMember = "CategoryName";
settings.SortOrder = DimensionSortOrder.Descending;
DashboardParameter parameter3 = new DashboardParameter("Parameter3", typeof(string), "1", "Select a category:", true, settings);

VB.NET

Dim settings As New DynamicListLookUpSettings()
settings.DataSource = sqlDataSource
settings.DataMember = "Categories"
settings.ValueMember = "CategoryID"
settings.DisplayMember = "CategoryName"
settings.SortOrder = DimensionSortOrder.Descending
Dim parameter3 As New DashboardParameter("Parameter3", GetType(String), "1", "Select a category:", True, settings)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataMember property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

web-forms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/CS/ASPxDashboard/Default.aspx.cs#L85

}
foreach (var parameter in dashboard.Parameters.Select(p => p.LookUpSettings).OfType<DynamicListLookUpSettings>().Where(p => Object.ReferenceEquals( p.DataSource, query.DataSource) && p.DataMember == query.Query.Name)) {
    parameter.DataMember = "";

winforms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/CS/WinFormsDashboard/ViewerForm.cs#L36

}
foreach (var parameter in e.Dashboard.Parameters.Select(p => p.LookUpSettings).OfType<DynamicListLookUpSettings>().Where(p => p.DataSource == query.DataSource && p.DataMember == query.Query.Name)) {
    parameter.DataMember = "";

winforms-dashboard-pass-dashboard-parameters-to-filter-string-in-code/CS/Dashboard_Parameters/Form1.cs#L24

settings.DataSource = parameterDataSource;
settings.DataMember = "Categories";
settings.ValueMember = "CategoryName";

VB.NET

web-forms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/VB/ASPxDashboard/Default.aspx.vb#L87

Next item
For Each parameter In dashboard.Parameters.Select(Function(p) p.LookUpSettings).OfType(Of DynamicListLookUpSettings)().Where(Function(p) Object.ReferenceEquals(p.DataSource, dsQuery.DataSource) AndAlso p.DataMember = dsQuery.Query.Name)
    parameter.DataMember = ""

winforms-dashboard-replace-sql-data-source-with-object-data-source-with-filtered-data/VB/WinFormsDashboard/ViewerForm.vb#L38

Next item
For Each parameter In e.Dashboard.Parameters.Select(Function(p) p.LookUpSettings).OfType(Of DynamicListLookUpSettings)().Where(Function(p) p.DataSource.Equals(query.DataSource) AndAlso p.DataMember = query.Query.Name)
    parameter.DataMember = ""

winforms-dashboard-pass-dashboard-parameters-to-filter-string-in-code/VB/Dashboard_Parameters/Form1.vb#L25

settings.DataSource = parameterDataSource
settings.DataMember = "Categories"
settings.ValueMember = "CategoryName"