CSharp Binding To Linq To Sql Query – ADO.Net Database

File: Employee.csusing 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>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.