SqlDataSource.SaveToXml() Method

Saves the XML definition of the SQL data source schema.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public override XElement SaveToXml()

VB.NET

Public Overrides Function SaveToXml As XElement

Returns

Type	Description
XElement	A XElement value containing an XML definition of the data source schema.

Related GitHub Examples

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

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#

DashboardUserBasedMVC/CS/MVCDashboard/Code/CustomDataSourceStorage.cs#L42

documents[sqlDataSourceId1] = new XDocument(sqlDataSource1.SaveToXml());
documents[sqlDataSourceId2] = new XDocument(sqlDataSource2.SaveToXml());

asp-net-web-forms-dashboard-switch-between-designer-and-viewer-on-client/CS/Dashboard_WebDashboard_2010/WebForm1.aspx.cs#L27

DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml());
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml());

web-forms-dashboard-add-custom-information-to-exported-dashboard/CS/WebDashboard_CustomExport/Default.aspx.cs#L24

DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml());
ASPxDashboard1.SetDataSourceStorage(dataSourceStorage);

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

XElement dsXML = dataSource.SaveToXml();
DevExpress.DataAccess.Sql.SqlDataSource sqlDS = new DevExpress.DataAccess.Sql.SqlDataSource();

asp-net-mvc-dashboard-switch-between-designer-and-viewer-on-client/CS/MVCxDashboard_PredefinedDataSources/App_Start/DashboardConfig.cs#L27

DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("xmlDataSource1", xmlDataSource.SaveToXml());
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml());

VB.NET

asp-net-web-forms-dashboard-switch-between-designer-and-viewer-on-client/VB/Dashboard_WebDashboard_2010/WebForm1.aspx.vb#L26

Dim dataSourceStorage As New DataSourceInMemoryStorage()
dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml())
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml())

web-forms-dashboard-add-custom-information-to-exported-dashboard/VB/WebDashboard_CustomExport/Default.aspx.vb#L23

Dim dataSourceStorage As New DataSourceInMemoryStorage()
dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml())
ASPxDashboard1.SetDataSourceStorage(dataSourceStorage)

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

Dim dsXML As XElement = dataSource.SaveToXml()
Dim sqlDS As New DevExpress.DataAccess.Sql.SqlDataSource()

asp-net-mvc-dashboard-switch-between-designer-and-viewer-on-client/VB/MVCxDashboard_PredefinedDataSources/App_Start/DashboardConfig.vb#L28

Dim dataSourceStorage As New DataSourceInMemoryStorage()
dataSourceStorage.RegisterDataSource("xmlDataSource1", xmlDataSource.SaveToXml())
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml())

reporting-winforms-specify-custom-names-for-field-list-data-items/VB/MySqlDataSource.vb#L13

Public Sub New(ByVal copyFrom As SqlDataSource)
    LoadFromXml(copyFrom.SaveToXml())
End Sub