1 <%@ Page Language="VB" ResponseEncoding="iso-8859-1" validateRequest="false" %>
\r
2 <%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %>
\r
3 <%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %>
\r
4 <My:dbLib id='app' runat='server' />
\r
6 <script runat="server">
\r
8 Sub Page_Load(Sender As object, e As EventArgs)
\r
10 dim arEmpSql as string() = {"LastName","', '","FirstName"}
\r
11 dim oSqlCompat=new sqlCompatibilty(app.dbDialect)
\r
12 EmployeeID.SelectSql="select EmployeeID," & oSqlCompat.Concat(arEmpSql,false) & " from employees order by LastName,FirstName"
\r
13 app.OpenGridForm(ex8n)
\r
18 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
\r
21 <title>Rico LiveGrid-Example 2 (editable)</title>
\r
23 <Rico:LoadClient checkQueryString='true' runat='server' />
\r
24 <link href="../demo.css" type="text/css" rel="stylesheet" />
\r
26 <style type="text/css">
\r
36 <div id='explanation'>
\r
37 Base Library: <script type='text/javascript'>document.write(Rico.Lib+' '+Rico.LibVersion);</script>
\r
38 <hr>The data on this grid can be edited using pop-up forms.
\r
39 Just click on a grid cell and then select Edit, Delete, or Add from the pop-up menu.
\r
40 Updates are disabled on the database, so you will get an error message if you try to save.
\r
41 <p>Rather than requesting data from RicoQuery, this page is able to process the AJAX
\r
42 data requests itself. No session variables are used.
\r
44 <p><strong>Orders Table (without sessions)</strong></p>
\r
47 <Rico:LiveGridEdit runat='server' id='ex8n' TableName='orders' DefaultSort='OrderID' FilterLocation='-1' sessions='false'>
\r
48 <Rico:CalendarControl runat='server' id='Cal' icon='rico-icon rico-calarrow' />
\r
49 <Rico:TreeControl runat='server' id='CustomerTree' icon='rico-icon rico-dotbutton' source='CustTree.aspx' />
\r
50 <Rico:ColumnGroup runat='server' heading='Basic Info' />
\r
51 <Rico:Column runat='server' heading='Order#' width='60' ColName='OrderID' EntryType='B' ColData='<auto>' ConfirmDeleteColumn='true' />
\r
52 <Rico:Column runat='server' heading='Customer' width='160' ColName='CustomerID' EntryType='CL' InsertOnly='true' SelectCtl='CustomerTree' SelectSql="select CustomerID,CompanyName from customers order by CompanyName" filterUI='t' />
\r
53 <Rico:Column runat='server' heading='Sales Person' width='140' ColName='EmployeeID' EntryType='SL' filterUI='s' id='EmployeeID' />
\r
54 <Rico:Column runat='server' heading='Order Date' width='100' ColName='OrderDate' EntryType='D' ColData='Today' SelectCtl='Cal' />
\r
55 <Rico:Column runat='server' heading='Required Date' width='100' ColName='RequiredDate' EntryType='D' ColData='Today' SelectCtl='Cal' />
\r
56 <Rico:Column runat='server' heading='Net Sale' width='80' format='DOLLAR' Formula='select sum(UnitPrice*Quantity*(1.0-Discount)) from order_details d where d.OrderID=t.OrderID' />
\r
58 <Rico:ColumnGroup runat='server' heading='Ship To' />
\r
59 <Rico:Column runat='server' heading='Name' width='150' ColName='ShipName' EntryType='B' />
\r
60 <Rico:Column runat='server' heading='Address' width='150' ColName='ShipAddress' EntryType='B' />
\r
61 <Rico:Column runat='server' heading='City' width='80' ColName='ShipCity' EntryType='B' filterUI='s' />
\r
62 <Rico:Column runat='server' heading='Region' width='80' ColName='ShipRegion' EntryType='T' />
\r
63 <Rico:Column runat='server' heading='Postal Code' width='80' ColName='ShipPostalCode' EntryType='T' />
\r
64 <Rico:Column runat='server' heading='Country' width='90' ColName='ShipCountry' EntryType='N' filterUI='s' control="new Rico.TableColumn.link('http://en.wikipedia.org/wiki/{11}','_blank')" />
\r
65 </Rico:LiveGridEdit>
\r