devexpress-examples / web-forms-dashboard-custom-database-schema-for-sql-data-sources Goto Github PK

View Code? Open in Web Editor NEW

This example demonstrates how to customize a database schema for an SQL data source.

License: Other

ASP.NET 6.66% C# 45.36% Visual Basic .NET 47.98%

web-forms-dashboard-custom-database-schema-for-sql-data-sources's Introduction

Dashboard for Web Forms - How to customize a database schema for SQL data sources

This example shows how to create a custom database schema for the dashboard. The example contains two implementation of the IDBSchemaProviderEx interface, LimitDBSchemaProvider and ManualDBSchemaProvider. Call the ASPxDashboard.SetDBSchemaProvider method to assign the database schema to the Web Dashboard.

To see the result, add a new query or edit the existing query.

The LimitDBSchemaProvider class

File: LimitDBSchemaProvider.cs (VB: LimitDBSchemaProvider.vb)

This provider displays only the following database entities:

Tables which names start with the letter C
Views which names start with Sales
Stored procedures with zero arguments

The ManualDBSchemaProvider class

File: ManualDBSchemaProvider.cs (VB: LimitDBSchemaProvider.vb)

This provider loads two tables (Categories and Products) for the NWindConnectionString connection. Both tables contain only two columns and the tables are linked by the CategoryID field.