SqlGridWidget Class

The class ScalarSqlCountWidget provides SQL Query grid widget

Inheritance Hierarchy

SystemObject
  Dynamicweb.Extensibility.AddInsConfigurableAddIn
    Dynamicweb.Dashboards.WidgetsDashboardWidget
      Dynamicweb.Dashboards.WidgetsDashboardElementWidget
        Dynamicweb.Dashboards.WidgetsGridWidget
          Dynamicweb.Dashboards.WidgetsSqlGridWidget

Namespace: Dynamicweb.Dashboards.Widgets
Assembly: Dynamicweb.Dashboards (in Dynamicweb.Dashboards.dll) Version: 2.9.4

Syntax

Copy

[AddInNameAttribute("SQL Query Table")]
[AddInDescriptionAttribute("SQL Query Table")]
[AddInIconAttribute(KnownIcon.Straighten)]
public class SqlGridWidget : GridWidget

<AddInNameAttribute("SQL Query Table")>
<AddInDescriptionAttribute("SQL Query Table")>
<AddInIconAttribute(KnownIcon.Straighten)>
Public Class SqlGridWidget
	Inherits GridWidget

The SqlGridWidget type exposes the following members.

Constructors

	Name	Description
	SqlGridWidget	The class ScalarSqlCountWidget constructor

Top

Properties

	Name	Description
	Columns	Gets or sets widget size (Inherited from DashboardWidget.)
	CreatedDate	Gets the created date and time. (Inherited from DashboardWidget.)
	Element	The to be shown (Inherited from DashboardElementWidget.)
	Id	Gets widget Id (Inherited from DashboardWidget.)
	InstantFetch	Gets or sets value indicating whether data should be fetch to widget instantly, otherwise - using ajax (Inherited from GridWidget.)
	MaxRecords	Gets or sets sql query
	ModifiedDate	Gets the last modified date and time. (Inherited from DashboardWidget.)
	OnRowClick	Gets or sets action for row on click event (Inherited from GridWidget.)
	Order	Gets or sets widget order (Inherited from DashboardWidget.)
	Query	Gets or sets sql query
	ShowTitle	Gets or sets value indicating whether to show widget title. (Inherited from DashboardWidget.)
	Title	Gets or sets widget title (Inherited from DashboardWidget.)
	TitleAction	Gets or sets widget title action (Inherited from DashboardWidget.)

Top

Methods

	Name	Description
	Fetch	Fetches widget with data (Inherited from GridWidget.)
	GetColumns	(Overrides GridWidgetGetColumns.)
	GetIdSuitableString	(Inherited from ConfigurableAddIn.)
	GetItems	(Overrides GridWidgetGetItems(IDashboard, String).)
	GetOptions	Return dropdown options (Inherited from DashboardWidget.)
	GetParametersToXml	(Inherited from ConfigurableAddIn.)
	GetParametersToXml(Boolean)	(Inherited from ConfigurableAddIn.)
	LoadParametersFromXml	(Inherited from ConfigurableAddIn.)
	Render	The method render widget and return html (Inherited from DashboardElementWidget.)
	RenderAdditionalContent	(Inherited from ConfigurableAddIn.)
	ScriptDependencies	Specifies relative paths to all script files that this widget is dependent upon. (Inherited from DashboardWidget.)
	SetValue	(Inherited from ConfigurableAddIn.)
	StylesheetDependencies	Specifies relative paths to all style files that this widget is dependent upon. (Inherited from DashboardWidget.)
	UpdateFromPost	(Inherited from ConfigurableAddIn.)

Top

Reference

Dynamicweb.Dashboards.Widgets Namespace