projects / infodrom / rico3 / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Changed asp and dotnet examples to use css sprites instead of images. Changed dotnet...
[infodrom/rico3] / examples / dotnet / ex2nosession.aspx
diff --git a/examples/dotnet/ex2nosession.aspx b/examples/dotnet/ex2nosession.aspx
index becd1a5..702eb1c 100644 (file)
--- a/examples/dotnet/ex2nosession.aspx
+++ b/examples/dotnet/ex2nosession.aspx
@@ -1,10 +1,5 @@
 <%@ Page Language="VB" ResponseEncoding="iso-8859-1" Debug="true" validateRequest="false" %>\r
-<%@ Register TagPrefix="Rico" TagName="LiveGrid" Src="../../plugins/dotnet/LiveGrid.ascx" %>\r
-<%@ Register TagPrefix="Rico" TagName="Column" Src="../../plugins/dotnet/GridColumn.ascx" %>\r
-<%@ Register TagPrefix="Rico" TagName="Panel" Src="../../plugins/dotnet/GridPanel.ascx" %>\r
-<%@ Register TagPrefix="Rico" TagName="sqlCompatibilty" Src="../../plugins/dotnet/sqlCompatibilty.ascx" %>\r
-<%@ Register TagPrefix="Rico" TagName="ricoResponse" Src="../../plugins/dotnet/ricoResponse.ascx" %>\r
-<%@ Register TagPrefix="My" TagName="LoadRicoClient" Src="LoadRicoClient.ascx" %>\r
+<%@ Register TagPrefix="Rico" Assembly="Rico" NameSpace="Rico" %>\r
 <%@ Register TagPrefix="My" TagName="dbLib" Src="dbConnect.ascx" %>\r
 <My:dbLib id='app' runat='server' />\r
 \r
@@ -15,12 +10,13 @@ Sub Page_Load(Sender As object, e As EventArgs)
   Session.Timeout=60\r
   dim arEmpSql as string() = {"LastName","', '","FirstName"}\r
   dim oSqlCompat=new sqlCompatibilty(app.dbDialect)\r
-  ex8n.columns(ex8n.ColIndex("EmployeeID")).SelectSql="select EmployeeID," & oSqlCompat.Concat(arEmpSql,false) & " from employees order by LastName,FirstName" \r
+  EmployeeID.SelectSql="select EmployeeID," & oSqlCompat.Concat(arEmpSql,false) & " from employees order by LastName,FirstName" \r
   ex8n.dataProvider=Request.ServerVariables("SCRIPT_NAME")\r
   app.OpenGridForm(ex8n)\r
 End Sub\r
 \r
 Protected Overrides Sub Render(writer as HTMLTextWriter)\r
+  RespObj.dbConnection=app.dbConnection\r
   select case ex8n.action\r
     case "table": \r
       RespObj.RenderFlag=false\r
@@ -29,10 +25,7 @@ Protected Overrides Sub Render(writer as HTMLTextWriter)
     case "upd":   ex8n.UpdateRecord(writer)\r
     case "del":   ex8n.DeleteRecord(writer)\r
     case "query":\r
-      RespObj.dbConnection=app.dbConnection\r
       RespObj.dbDialect=app.dbDialect\r
-      RespObj.sendDebugMsgs=true   ' true for development, false for production\r
-      RespObj.LogSqlOnError=true   ' true for development, false for production\r
       RespObj.oParse=ex8n.ParseClone()\r
       RespObj.RunQuery(writer)\r
   end select\r
@@ -45,22 +38,9 @@ End Sub
 <head>\r
 <title>Rico LiveGrid-Example 2 (editable)</title>\r
 \r
-<My:LoadRicoClient id='initlibs' runat='server' modules='Calendar,Tree' />\r
+<Rico:LoadClient checkQueryString='true' runat='server' />\r
 <link href="../demo.css" type="text/css" rel="stylesheet" />\r
 \r
-<script type='text/javascript'>\r
-\r
-// ricoLiveGridForms will call orders_FormInit right before grid & form initialization.\r
-\r
-function ex8_FormInit() {\r
-  var cal=new Rico.CalendarControl("Cal");\r
-  Rico.EditControls.register(cal, Rico.imgDir+'calarrow.png');\r
-  \r
-  var CustTree=new Rico.TreeControl("CustomerTree","CustTree.aspx");\r
-  Rico.EditControls.register(CustTree, Rico.imgDir+'dotbutton.gif');\r
-}\r
-</script>\r
-\r
 <style type="text/css">\r
 div.ricoLG_cell {\r
   white-space:nowrap;\r
@@ -82,12 +62,13 @@ data requests itself. No session variables are used.
 <p><strong>Orders Table (without sessions)</strong></p>\r
 \r
 \r
-<Rico:LiveGrid runat='server' id='ex8n' formView='true' TableName='orders' DefaultSort='OrderID' FilterLocation='-1' sessions='false'>\r
-<GridColumns>\r
+<Rico:LiveGridEdit runat='server' id='ex8n' TableName='orders' DefaultSort='OrderID' FilterLocation='-1' sessions='false'>\r
+  <Rico:CalendarControl runat='server' id='Cal' icon='rico-icon rico-calarrow' />\r
+  <Rico:TreeControl runat='server' id='CustomerTree' icon='rico-icon rico-dotbutton' source='CustTree.aspx' />\r
   <Rico:Panel runat='server' heading='Basic Info' />\r
   <Rico:Column runat='server' heading='Order#'        width='60'  ColName='OrderID'      EntryType='B' ColData='<auto>' ConfirmDeleteColumn='true' />\r
   <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
-  <Rico:Column runat='server' heading='Sales Person'  width='140' ColName='EmployeeID'   EntryType='SL' filterUI='s' />\r
+  <Rico:Column runat='server' heading='Sales Person'  width='140' ColName='EmployeeID'   EntryType='SL' filterUI='s' id='EmployeeID' />\r
   <Rico:Column runat='server' heading='Order Date'    width='100' ColName='OrderDate'    EntryType='D' ColData='Today' SelectCtl='Cal' />\r
   <Rico:Column runat='server' heading='Required Date' width='100' ColName='RequiredDate' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
   <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
@@ -99,10 +80,9 @@ data requests itself. No session variables are used.
   <Rico:Column runat='server' heading='Region'      width='80'  ColName='ShipRegion'     EntryType='T' />\r
   <Rico:Column runat='server' heading='Postal Code' width='80'  ColName='ShipPostalCode' EntryType='T' />\r
   <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
-</GridColumns>\r
-</Rico:LiveGrid>\r
+</Rico:LiveGridEdit>\r
 \r
-<Rico:ricoResponse id="RespObj" runat="server" />\r
+<Rico:Response id="RespObj" runat="server" />\r
 \r
 </body>\r
 </html>\r
OpenRico 3 (imported branch from subversion)