How to: Save Dashboards Created in ASPxDashboard to a DataSet

  • 4 minutes to read

The following example shows how to create a custom dashboard storage for ASPxDashboard by implementing the IEditableDashboardStorage interface. In this example, a DataSet is used as an in-memory storage of dashboards. This DataSet can be used later to save dashboards in the database using DataAdapter.

View Example

Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Linq
Imports System.Web

Namespace WebDesigner_CustomDashboardStorage
    Public Class DashboardStorageDataSet
        Inherits DataSet

        Public Sub New()
            Dim table As New DataTable("Dashboards")
            Dim idColumn As New DataColumn("DashboardID", GetType(Int32))
            idColumn.AutoIncrement = True
            idColumn.AutoIncrementSeed = 1
            idColumn.Unique = True
            idColumn.AllowDBNull = False
            table.Columns.Add(idColumn)
            table.Columns.Add("DashboardXml", GetType(String))
            table.Columns.Add("DashboardName", GetType(String))
            table.PrimaryKey = New DataColumn() {idColumn}
            Me.Tables.Add(table)
        End Sub
    End Class
End Namespace