How to: Save Dashboards Created in ASPxDashboard to a DataSet

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.

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("DashboardXml", GetType(String))
            table.Columns.Add("DashboardName", GetType(String))
            table.PrimaryKey = New DataColumn() {idColumn}
        End Sub
    End Class
End Namespace