GridControl.DataSource Property

Gets or sets the grid control’s data source.

Namespace: DevExpress.XtraGrid

Assembly: DevExpress.XtraGrid.v19.1.dll

Declaration

C#

[DefaultValue(null)]
[DXCategory("Data")]
public virtual object DataSource { get; set; }

VB.NET

<DefaultValue(Nothing)>
<DXCategory("Data")>
Public Overridable Property DataSource As Object

Property Value

Type	Default	Description
Object	*null*	An object representing the grid control’s data source.

Remarks

Refer to the Data Binding and Master-Detail Relationships topics for information on which objects can be assigned to the DataSource property.

After the DataSource property is set to null, the ColumnView.FocusedRowHandle of the GridControl.MainView is set to GridControl.InvalidRowHandle. After a new data source is assigned to the DataSource property, the ColumnView.FocusedRowHandle is set to 0, to refer to the first data record.

The code sample below illustrates how to bind the GridControl to XML data.

C#

xmlDataSet.ReadXml(@".\products.xml");
gridControl1.DataSource = xmlDataSet.Tables["product"];

VB.NET

xmlDataSet.ReadXml(".\products.xml")
gridControl1.DataSource = xmlDataSet.Tables("product")

Related GitHub Examples

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

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_report-server-how-to-manage-scheduled-jobs-from-a-windows-forms-application-t431255/CS/ScheduledTasksAPIClientDemo/MainForm.cs#L42

void FillScheduledJobListBox(IEnumerable<ScheduledJobCatalogItemDto> scheduledJobs) {
    scheduledJobsGrid.DataSource = scheduledJobs;
    scheduledJobsView.BestFitColumns();

mvvmexpenses-sample-application-t254492/CS/MVVMExpenses/Views/Account/AccountsEditFormView.cs#L29

fluent.SetBinding(
    gridControl1, gc => gc.DataSource, x => x.AccountTransactionDetails.Entities);

machine-learning-chart-demo-e20012/CS/MachineLearningDemo/Main.cs#L34

_data = StudentData.GetData();
gridStudent.DataSource = _data;
gridStudent.RefreshDataSource();

how-to-hide-master-view-rows-if-their-child-rows-are-totally-filtered-out-in-the-child-view-e3747/CS/E3747CS/Form1.cs#L16

bs.DataSource = CreateObjectSource(3, 5);
gridControl1.DataSource = bs;
new FilterHelper(gridView1, gridView2);

XDL_how-to-convert-the-criteriaoperator-to-a-lambda-expression-to-use-it-for-iqueryable-e2596/CS/WindowsFormsApplication152/Form1.cs#L37

gridControl1.DataSource = source.ToList();
CreateFilterColumns();

VB.NET

Reporting_report-server-how-to-manage-scheduled-jobs-from-a-windows-forms-application-t431255/VB/ScheduledTasksAPIClientDemo/MainForm.vb#L42

Private Sub FillScheduledJobListBox(ByVal scheduledJobs As IEnumerable(Of ScheduledJobCatalogItemDto))
    scheduledJobsGrid.DataSource = scheduledJobs
    scheduledJobsView.BestFitColumns()

mvvmexpenses-sample-application-t254492/VB/MVVMExpenses/Views/Account/AccountsEditFormView.vb#L29

fluent.SetObjectDataSourceBinding(accountBindingSource, Function(x) x.Entity, Sub(x) x.Update())
fluent.SetBinding(GridControl1, Function(gc) gc.DataSource, Function(x) x.AccountTransactionDetails.Entities)
CType(GridControl1.MainView, DevExpress.XtraGrid.Views.Grid.GridView).Columns("Account").Visible = False

machine-learning-chart-demo-e20012/VB/MachineLearningDemo/Main.vb#L32

_data = StudentData.GetData()
gridStudent.DataSource = _data
gridStudent.RefreshDataSource()

how-to-hide-master-view-rows-if-their-child-rows-are-totally-filtered-out-in-the-child-view-e3747/VB/E3747CS/Form1.vb#L15

bs.DataSource = CreateObjectSource(3, 5)
gridControl1.DataSource = bs
Dim tempVar As New FilterHelper(gridView1, gridView2)

XDL_how-to-convert-the-criteriaoperator-to-a-lambda-expression-to-use-it-for-iqueryable-e2596/VB/WindowsFormsApplication152/Form1.vb#L36

gridControl1.DataSource = source.ToList()
CreateFilterColumns()