<%@ Page Language="C#" AutoEventWireup="true" Codebehind="MicrosoftInline.aspx.cs" Inherits="EntitySpaces.DataSource.Demo.MicrosoftInline" %><%@ Register Assembly="EntitySpaces.Web" Namespace="EntitySpaces.Web" TagPrefix="cc1" %><!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>Inline GridView CRUD</title></head><body> <form id="form1" runat="server"> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="EmployeeID" DataSourceID="EsDataSource1" AllowPaging="True" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" PageSize="5" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"> <Columns> <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" InsertVisible="False" ReadOnly="True" SortExpression="EmployeeID" /> <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" /> <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" /> <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" /> <asp:BoundField DataField="TitleOfCourtesy" HeaderText="TitleOfCourtesy" SortExpression="TitleOfCourtesy" /> <asp:BoundField DataField="BirthDate" HeaderText="BirthDate" SortExpression="BirthDate" /> <asp:BoundField DataField="HireDate" HeaderText="HireDate" SortExpression="HireDate" /> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="Gainsboro" /> </asp:GridView> <br /> <cc1:esDataSource ID="EsDataSource1" runat="server" OnesSelect="EsDataSource1_esSelect" AutoPaging="true" AutoSorting="true" OnesCreateEntity="EsDataSource1_esCreateEntity" /> </form></body></html>
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using BusinessObjects;namespace EntitySpaces.DataSource.Demo{ public partial class MicrosoftInline : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { GetEmployeeCount(); } } private void GetEmployeeCount() { Employees emp = new Employees(); emp.Query.es.CountAll = true; emp.Query.es.CountAllAlias = "Count"; if (emp.Query.Load()) { EsDataSource1.TotalRowCount = (int)emp.GetColumn("Count"); } GridView1.Sort(EmployeesMetadata.PropertyNames.LastName, SortDirection.Ascending); } protected void EsDataSource1_esSelect(object sender, EntitySpaces.Web.esDataSourceSelectEventArgs e) { EmployeesCollection employees = new EmployeesCollection(); e.Collection = employees; } protected void EsDataSource1_esCreateEntity(object sender, EntitySpaces.Web.esDataSourceCreateEntityEventArgs e) { Employees employee = new Employees(); if (e.PrimaryKeys == null) { employee.AddNew(); } else { employee.LoadByPrimaryKey((int)e.PrimaryKeys[0]); } e.Entity = employee; } }}
Regards, Scott Schecter EntitySpaces | Blog | Twitter