ExcelDataSource.RebuildResultSchema() Method

Updates the result schema of a data source available on the client according to the current data source structure.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v20.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.WindowsDesktop.DataAccess

Declaration

C#

public void RebuildResultSchema()

VB.NET

Public Sub RebuildResultSchema

Remarks

After you have added the ExcelDataSource component to an application, you can configure the data connection by using the commands available in the component’s smart tag.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the RebuildResultSchema() 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#

reporting-web-forms-report-designer-add-data-sources/CS/WebApplication1/Default.aspx.cs#L58

});
excelDS.RebuildResultSchema();
return excelDS;

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/ExcelDataSourceSnippets/Code.cs#L51

};
excelDataSource.RebuildResultSchema();
return excelDataSource;

VB.NET

reporting-web-forms-report-designer-add-data-sources/VB/WebApplication1/Default.aspx.vb#L51

excelDS.Schema.AddRange(New DevExpress.DataAccess.Excel.FieldInfo() { fieldInfo1, fieldInfo2, fieldInfo3 })
excelDS.RebuildResultSchema()
Return excelDS

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/ExcelDataSourceSnippets/Code.vb#L45

excelDataSource.SourceOptions = New ExcelSourceOptions() With {.ImportSettings = New ExcelWorksheetSettings("Sheet")}
excelDataSource.RebuildResultSchema()
Return excelDataSource