本文介绍了一个使用C#和LINQ进行数据绑定的例子。通过定义一个Customer类并使用属性来映射数据库字段，实现了从名为northwind的数据库中筛选位于伦敦的客户，并将查询结果显示在名为dataGrid1的控件上。
数据实体类：
[Table(Name = "customers")]
[Table(Name = "customers")]
public class Customer
{
private string _CustomerID;
[Column(IsPrimaryKey=true,Storage="_CustomerID")]
public string CustomerID
{
get
{
return this._CustomerID;
www.wpf123.com
}
set
{
this._CustomerID = value;
}
}
private string _City;
[Column(Storage = "_City")]
public string City
{
get
{
return this._City;
}
set
{
this._City = value;
}
}
private string _CompanyName;
[Column(Storage = "_CompanyName")]
public string CompanyName
{
get
{
return this._CompanyName;
}
set
{
this._CompanyName = value;
}
}
dataGrid数据绑定：
dataGrid数据绑定：
System.Data.Linq.DataContext db = new DataContext("Data Source=.;Initial Catalog=northwind;Integrated Security=True");
Table<Customer> customers = db.GetTable<Customer>();
IQueryable<Customer> custQuery =
from cust in customers
where cust.City == "London"
select cust;
dataGrid1.ItemsSource = custQuery.ToList();
http://www.wpf123.com/news/?185.html
扫一扫
827
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
