Binding to a LINQ to SQL Query
File: Employee.cs
using System.Collections.Generic;
using System.Linq;
using System.Data.Linq;
public class Employee
{
public string _firstName;
public string _lastName;
public bool _retired;
public string FirstName
{
get { return _firstName; }
}
public string LastName
{
get { return _lastName; }
}
public bool Retired
{
get { return _retired; }
}
public Employee(string firstName, string lastName, bool retired)
{
_firstName = firstName;
_lastName = lastName;
_retired = retired;
}
public static IEnumerable<Employee> Select()
{
EmployeesDataContext db = new EmployeesDataContext();
return db.Employees.OrderBy( e=>e.LastName );
}
}
File: Default.aspx
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Show LINQ</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView
id="grdEmployees"
DataSourceID="srcEmployees"
runat="server" />
<asp:ObjectDataSource
id="srcEmployees"
TypeName="Employee"
SelectMethod="Select"
Runat="server" />
</div>
</form>
</body>
</html>
Related examples in the same category