This example binds the WinForms Data Grid control to data using the LINQ to SQL provider. The grid control is bound to LinqServerModeSource. The grid control operates in server mode.
The example fetches data from the AdventureWorks database on a local SQL Server. SQL queries are logged in the output window in the Visual Studio IDE.
Files to Review
Documentation
Does this example address your development requirements/objectives?
(you will be redirected to DevExpress.com to submit your response)
Example Code
LinqServerModeOnAdvWorks/Form1.cs(vb)
C#using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraGrid.Columns;
namespace LinqServerModeOnAdvWorks {
public partial class Form1 : Form {
public Form1() {
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e) {
gridControl1.ServerMode = true;
AdvWorksDataContext dc = new AdvWorksDataContext();
dc.Log = Console.Out; // log queries
linqServerModeSource1.QueryableSource = dc.PurchaseOrderHeaders;
gridControl1.DataSource = linqServerModeSource1;
}
}
}