DevExpress WPF擁有120+個控件和庫，將幫助您交付滿足甚至超出企業(yè)需求的高性能業(yè)務(wù)應(yīng)用程序。通過DevExpress WPF能創(chuàng)建有著強大互動功能的XAML基礎(chǔ)應(yīng)用程序，這些應(yīng)用程序?qū)Ｗ⒂诋敶蛻舻男枨蠛蜆?gòu)建未來新一代支持觸摸的解決方案。 無論是Office辦公軟件的衍伸產(chǎn)品，還是以數(shù)據(jù)為中心的商業(yè)智能產(chǎn)品，都能通過DevExpress WPF控件來實現(xiàn)。

本文演示如何使用InfiniteAsyncSource或PagedAsyncSource虛擬源將GridControl綁定到數(shù)據(jù)源。，歡迎下載最新版組件體驗！

獲取DevExpress WPF v25.1正式版下載

DevExpress技術(shù)交流群11：749942875      歡迎一起進群討論

示例數(shù)據(jù)

在本教程中，將IssuesContext 后代用作示例數(shù)據(jù)源。

TIP：DevExpress虛擬源支持Entity Framework、Entity Framework Core和XPO源。

安裝EntityFramework NuGet包。

將以下代碼添加到應(yīng)用程序中。

示例數(shù)據(jù)

Issue.cs

using System.Collections.Generic;

public class Issue {
public int Id { get; set; }
public string Subject { get; set; }
public int UserId { get; set; }
public virtual User User { get; set; }
public DateTime Created { get; set; }
public int Votes { get; set; }
public Priority Priority { get; set; }
public Issue() {
Created = DateTime.Now;
}
}
public enum Priority { Low, BelowNormal, Normal, AboveNormal, High }

public class User {
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public virtual ICollection<Issue> Issues { get; set; }
}

Issue.vb

Imports System.Collections.Generic

Public Class Issue
Public Property Id As Integer
Public Property Subject As String
Public Property UserId As Integer
Public Overridable Property User As User
Public Property Created As Date
Public Property Votes As Integer
Public Property Priority As Priority

Public Sub New()
Created = Date.Now
End Sub
End Class

Public Enum Priority
Low
BelowNormal
Normal
AboveNormal
High
End Enum

Public Class User
Public Property Id As Integer
Public Property FirstName As String
Public Property LastName As String
Public Overridable Property Issues As ICollection(Of Issue)
End Class

IssuesContextInitializer.cs

using System;
using System.Data.Entity;
using System.Linq;

public class IssuesContextInitializer
: DropCreateDatabaseIfModelChanges<IssuesContext> {

public static void ResetData() {
using(var context = new IssuesContext()) {
context.Users.Load();
context.Users.RemoveRange(context.Users);
context.SaveChanges();
CreateData(context);
}
}

protected override void Seed(IssuesContext context) {
base.Seed(context);
CreateData(context);
}

static void CreateData(IssuesContext context) {
var users = OutlookDataGenerator.Users
.Select(x =>
{
var split = x.Split(' ');
return new User() {
FirstName = split[0],
LastName = split[1]
};
})
.ToArray();
context.Users.AddRange(users);
context.SaveChanges();

var rnd = new Random(0);
var issues = Enumerable.Range(0, 1000)
.Select(i => new Issue()
{
Subject = OutlookDataGenerator.GetSubject(),
UserId = users[rnd.Next(users.Length)].Id,
Created = DateTime.Today.AddDays(-rnd.Next(30)),
Priority = OutlookDataGenerator.GetPriority(),
Votes = rnd.Next(100),
})
.ToArray();
context.Issues.AddRange(issues);

context.SaveChanges();
}
}

IssuesContextInitializer.vb

Imports System
Imports System.Data.Entity
Imports System.Linq

Public Class IssuesContextInitializer
Inherits DropCreateDatabaseIfModelChanges(Of IssuesContext)

': DropCreateDatabaseAlways<IssuesContext> {

Public Shared Sub ResetData()
Using context = New IssuesContext()
context.Users.Load()
context.Users.RemoveRange(context.Users)
context.SaveChanges()
CreateData(context)
End Using
End Sub

Protected Overrides Sub Seed(ByVal context As IssuesContext)
MyBase.Seed(context)
CreateData(context)
End Sub

Private Shared Sub CreateData(ByVal context As IssuesContext)
Dim users = OutlookDataGenerator.Users.[Select](Function(x)
Dim split = x.Split(" "c)
Return New User() With {
.FirstName = split(0),
.LastName = split(1)
}
End Function).ToArray()
context.Users.AddRange(users)
context.SaveChanges()
Dim rnd = New Random(0)
Dim issues = Enumerable.Range(0, 1000).[Select](Function(i) New Issue() With {
.Subject = OutlookDataGenerator.GetSubject(),
.UserId = users(rnd.Next(users.Length)).Id,
.Created = Date.Today.AddDays(-rnd.Next(30)),
.Priority = OutlookDataGenerator.GetPriority(),
.Votes = rnd.Next(100)
}).ToArray()
context.Issues.AddRange(issues)
context.SaveChanges()
End Sub
End Class

IssuesContext.cs

using System.Data.Entity;

public class IssuesContext : DbContext {
static IssuesContext() {
Database.SetInitializer(new IssuesContextInitializer());
}
public IssuesContext() { }

protected override void OnModelCreating(DbModelBuilder modelBuilder) {
base.OnModelCreating(modelBuilder);

modelBuilder.Entity<Issue>()
.HasIndex(x => x.Created);

modelBuilder.Entity<Issue>()
.HasIndex(x => x.Votes);
}

public DbSet<Issue> Issues { get; set; }
public DbSet<User> Users { get; set; }
}

IssuesContext.vb

Imports System.Data.Entity

Public Class IssuesContext
Inherits DbContext

Shared Sub New()
Database.SetInitializer(New IssuesContextInitializer())
End Sub

Public Sub New()
End Sub

Protected Overrides Sub OnModelCreating(ByVal modelBuilder As DbModelBuilder)
MyBase.OnModelCreating(modelBuilder)
modelBuilder.Entity(Of Issue)().HasIndex(Function(x) x.Created)
modelBuilder.Entity(Of Issue)().HasIndex(Function(x) x.Votes)
End Sub

Public Property Issues As DbSet(Of Issue)
Public Property Users As DbSet(Of User)
End Class

OutlookDataGenerator.cs

public static class OutlookDataGenerator {
static Random rnd = new Random(0);
static string[] Subjects = new string[] { "Developer Express MasterView. Integrating the control into an Accounting System.",
"Web Edition: Data Entry Page. There is an issue with date validation.",
"Payables Due Calculator is ready for testing.",
"Web Edition: Search Page is ready for testing.",
"Main Menu: Duplicate Items. Someone must review all menu items in the system.",
"Receivables Calculator. Where can I find the complete specs?",
"Ledger: Inconsistency. Please fix it.",
"Receivables Printing module is ready for testing.",
"Screen Redraw. Someone must look at it.",
"Email System. What library are we going to use?",
"Cannot add new vendor. This module doesn't work!",
"History. Will we track sales history in our system?",
"Main Menu: Add a File menu. File menu item is missing.",
"Currency Mask. The current currency mask is completely unusable.",
"Drag & Drop operations are not available in the scheduler module.",
"Data Import. What database types will we support?",
"Reports. The list of incomplete reports.",
"Data Archiving. We still don't have these features in our application.",
"Email Attachments. Is it possible to add multiple attachments? I haven't found a way to do this.",
"Check Register. We are using different paths for different modules.",
"Data Export. Our customers asked us for export to Microsoft Excel."};

public static readonly string[] Users = new string[] {
"Peter Dolan",
"Ryan Fischer",
"Richard Fisher",
"Tom Hamlett",
"Mark Hamilton",
"Steve Lee",
"Jimmy Lewis",
"Jeffrey McClain",
"Andrew Miller",
"Dave Murrel",
"Bert Parkins",
"Mike Roller",
"Ray Shipman",
"Paul Bailey",
"Brad Barnes",
"Carl Lucas",
"Jerry Campbell",
};

public static string GetSubject() {
return Subjects[rnd.Next(Subjects.Length - 1)];
}

public static string GetFrom() {
return Users[rnd.Next(Users.Length)];
}
public static Priority GetPriority() {
return (Priority)rnd.Next(5);
}
}

OutlookDataGenerator.vb

Public Module OutlookDataGenerator
Private rnd As Random = New Random(0)
Private Subjects As String() = New String() {"Developer Express MasterView. Integrating the control into an Accounting System.", "Web Edition: Data Entry Page. There is an issue with date validation.", "Payables Due Calculator is ready for testing.", "Web Edition: Search Page is ready for testing.", "Main Menu: Duplicate Items. Someone must review all menu items in the system.", "Receivables Calculator. Where can I find the complete specs?", "Ledger: Inconsistency. Please fix it.", "Receivables Printing module is ready for testing.", "Screen Redraw. Someone must look at it.", "Email System. What library are we going to use?", "Cannot add new vendor. This module doesn't work!", "History. Will we track sales history in our system?", "Main Menu: Add a File menu. File menu item is missing.", "Currency Mask. The current currency mask is completely unusable.", "Drag & Drop operations are not available in the scheduler module.", "Data Import. What database types will we support?", "Reports. The list of incomplete reports.", "Data Archiving. We still don't have these features in our application.", "Email Attachments. Is it possible to add multiple attachments? I haven't found a way to do this.", "Check Register. We are using different paths for different modules.", "Data Export. Our customers asked us for export to Microsoft Excel."}
Public ReadOnly Users As String() = New String() {"Peter Dolan", "Ryan Fischer", "Richard Fisher", "Tom Hamlett", "Mark Hamilton", "Steve Lee", "Jimmy Lewis", "Jeffrey McClain", "Andrew Miller", "Dave Murrel", "Bert Parkins", "Mike Roller", "Ray Shipman", "Paul Bailey", "Brad Barnes", "Carl Lucas", "Jerry Campbell"}

Public Function GetSubject() As String
Return Subjects(rnd.Next(Subjects.Length - 1))
End Function

Public Function GetFrom() As String
Return Users(rnd.Next(Users.Length))
End Function

Public Function GetPriority() As Priority
Return CType(rnd.Next(5), Priority)
End Function
End Module

將GridControl綁定到數(shù)據(jù)

1. 切換到涉及視圖，打開GridControl的并調(diào)用。

2. 選擇IssuesContext數(shù)據(jù)源。

3. 選擇Issue表。

4. 選擇InfiniteAsyncSource綁定模型，來無限滾動顯示數(shù)據(jù)。或者，您可以選擇PagedAsyncSource模型在頁面中顯示數(shù)據(jù)。

5. 確保Key Property設(shè)置為Id。

6. 在MainWindow.xaml.cs/MainWindow.xaml.vb中選擇Code-Behind來生成綁定代碼。

運行應(yīng)用程序。

MVVM技術(shù)

要在視圖模型中生成綁定代碼，請遵循以下步驟。

創(chuàng)建一個ViewModel模板，實現(xiàn)ViewModelBase并重建解決方案：

ViewModel.cs

using DevExpress.Mvvm;

namespace WPFBlankAppWithDatabase {
public class ViewModel : ViewModelBase {

}
}

ViewModel.vb

Imports DevExpress.Mvvm

Namespace WPFBlankAppWithDatabase
Public Class ViewModel
Inherits ViewModelBase

End Sub
End Class
End Namespace

請執(zhí)行步驟1-5。

選擇View Model將代碼添加到視圖模型中。

單擊Select a Data Context，選擇ViewModel類并點擊OK。

啟用Set selected class as the data context選項然后點擊Finish。

Items Source Wizard在ViewModel中生成數(shù)據(jù)綁定代碼，并在XAML中指定數(shù)據(jù)上下文和GridControl選項，運行應(yīng)用程序來查看結(jié)果。

更多產(chǎn)品資訊及授權(quán)，歡迎來電咨詢：023-68661681

關(guān)于慧都科技

慧都是?家?業(yè)數(shù)字化解決?案公司，專注于軟件、?油與?業(yè)領(lǐng)域，以深?的業(yè)務(wù)理解和?業(yè)經(jīng)驗，幫助企業(yè)實現(xiàn)智能化轉(zhuǎn)型與持續(xù)競爭優(yōu)勢。

慧都是DevExpress的中國區(qū)的合作伙伴，DevExpress作為用戶界面領(lǐng)域的優(yōu)秀產(chǎn)品，幫助企業(yè)高效構(gòu)建權(quán)限管理、數(shù)據(jù)可視化（如網(wǎng)格/圖表/儀表盤）、跨平臺系統(tǒng)（WinForms/ASP.NET/.NET MAUI）及行業(yè)定制解決方案，加速開發(fā)并強化交互體驗。