devexpress-examples / how-to-bind-linqinstantfeedbacksource-to-gridcontrol-e2805

Bind the WinForms Grid control to a queryable source (LinqInstantFeedbackSource).

WinForms Data Grid - Bind to a queryable source (LinqInstantFeedbackSource)

This example shows how to bind the WinForms Data Grid to LinqInstantFeedbackSource.

Set the LinqInstantFeedbackSource.KeyExpression property to a key property name.

linqInstantFeedbackSource.KeyExpression = "SupplierID";

Handle the LinqInstantFeedbackSource.GetQueryable event. Set the e.QueryableSource property.

void OnGetQueryable(object sender, GetQueryableEventArgs e) {
    NorthwindClassesDataContext dt = new NorthwindClassesDataContext();
    e.QueryableSource = dt.Suppliers;
    e.Tag = dt;  
}

Handle the LinqInstantFeedbackSource.DismissQueryable event to dispose of a DataContext object when it is no longer required.

void OnDismissQueryable(object sender, GetQueryableEventArgs e) {
    (e.Tag as NorthwindClassesDataContext).Dispose();
}

Bind LinqInstantFeedbackSource to the Grid control.

gridControl1.DataSource = linqInstantFeedbackSource;

Files to Review

• Main.cs (VB: Main.vb)

See Also

• Large Data Sources: Server and Instant Feedback Modes