<%@ Page Language="VB" ResponseEncoding="iso-8859-1" Debug="true" %>\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="sqlCompatibilty" Src="../../plugins/dotnet/sqlCompatibilty.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
Session.Timeout=60\r
dim arEmpSql as string() = {"%alias%LastName","', '","%alias%FirstName"}\r
dim oSqlCompat=new sqlCompatibilty(app.dbDialect)\r
- emp.getColumnByName("ReportsTo").SelectSql="select EmployeeID," & oSqlCompat.Concat(arEmpSql,false) & " from employees order by LastName,FirstName" \r
+ ReportsTo.SelectSql="select EmployeeID," & oSqlCompat.Concat(arEmpSql,false) & " from employees order by LastName,FirstName" \r
app.OpenGridForm(emp)\r
End Sub\r
\r
-Protected Overrides Sub Render(writer as HTMLTextWriter)\r
- select case emp.action\r
- case "table": MyBase.Render(writer)\r
- case "ins": emp.InsertRecord(writer)\r
- case "upd": emp.UpdateRecord(writer)\r
- case "del": emp.DeleteRecord(writer)\r
- end select\r
-End Sub\r
-\r
</script>\r
\r
\r
<head>\r
<title>Rico LiveGrid-Northwind Employees</title>\r
\r
-<My:LoadRicoClient id='initlibs' runat='server' modules='Calendar' />\r
+<Rico:LoadClient checkQueryString='true' runat='server' />\r
<link href="../demo.css" type="text/css" rel="stylesheet" />\r
\r
-<script type='text/javascript'>\r
+</head>\r
\r
-// ricoLiveGridForms will call emp_FormInit right before form initialization.\r
\r
-function emp_FormInit() {\r
- var cal=new Rico.CalendarControl("Cal");\r
- Rico.EditControls.register(cal, Rico.imgDir+'calarrow.png');\r
-}\r
-</script>\r
-\r
-<style type="text/css">\r
-div.ricoLG_cell {\r
- white-space:nowrap;\r
-}\r
-</style>\r
-</head>\r
<body>\r
\r
-<table id='explanation' border='0' cellpadding='0' cellspacing='5' style='clear:both'><tr valign='top'><td>\r
+<div id='explanation'>\r
Base Library: \r
<script type='text/javascript'>\r
document.write(Rico.Lib+' '+Rico.LibVersion);\r
Notice on the Edit form how the Rico Calendar is used to change dates. \r
Updates are disabled on the database, so you will get an error message if you try to save.\r
<a href='ricoQuery.aspx?id=ex2x&offset=0&page_size=10&get_total=true'>View the AJAX response (XML)</a>.\r
-</td>\r
-<td>\r
-<script type="text/javascript"><!--\r
-google_ad_client = "pub-7218597156507462";\r
-/* 125x125, created 5/11/09 */\r
-google_ad_slot = "9298106441";\r
-google_ad_width = 125;\r
-google_ad_height = 125;\r
-//-->\r
-</script>\r
-<script type="text/javascript"\r
-src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\r
-</script>\r
-</td>\r
-</tr></table>\r
+</div>\r
<p><strong>Employees Table</strong></p>\r
\r
-<Rico:LiveGrid runat='server' id='emp' TableName='employees' formView='true' DefaultSort='t.LastName,t.FirstName' menuEvent='click' frozenColumns='2' highlightElem='cursorRow'>\r
-<GridColumns>\r
- <Rico:Column runat='server' ColName='EmployeeID' heading='Emp#' width='60' EntryType='B' ColData='<auto>' />\r
- <Rico:Column runat='server' ColName='LastName' heading='Last Name' width='100' EntryType='B' />\r
- <Rico:Column runat='server' ColName='FirstName' heading='First Name' width='100' EntryType='B' />\r
- <Rico:Column runat='server' ColName='Title' heading='Title' width='120' EntryType='T' />\r
- <Rico:Column runat='server' ColName='TitleOfCourtesy' heading='Title (Courtesy)' width='90' EntryType='T' />\r
- <Rico:Column runat='server' ColName='BirthDate' heading='Birth Date' width='100' datatype='date' EntryType='D' SelectCtl='Cal' />\r
- <Rico:Column runat='server' ColName='HireDate' heading='Hire Date' width='100' datatype='date' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
- <Rico:Column runat='server' ColName='Address' heading='Address' width='100' EntryType='T' />\r
- <Rico:Column runat='server' ColName='City' heading='City' width='100' EntryType='T' />\r
- <Rico:Column runat='server' ColName='Region' heading='Region' width='100' EntryType='N' />\r
- <Rico:Column runat='server' ColName='PostalCode' heading='Postal Code' width='100' EntryType='T' />\r
- <Rico:Column runat='server' ColName='Country' heading='Country' width='100' EntryType='N' />\r
- <Rico:Column runat='server' ColName='HomePhone' heading='Home Phone' width='100' EntryType='T' />\r
- <Rico:Column runat='server' ColName='Extension' heading='Extension' width='100' EntryType='T' />\r
- <Rico:Column runat='server' ColName='ReportsTo' heading='ReportsTo' width='100' EntryType='SL' />\r
-</GridColumns>\r
-</Rico:LiveGrid>\r
+<Rico:LiveGridEdit runat='server' id='emp' DefaultSort='t.LastName,t.FirstName' menuEvent='click' frozenColumns='2' highlightElem='cursorRow'>\r
+ <Rico:Table runat='server' TblName='employees' />\r
+ <Rico:CalendarControl runat='server' id='Cal' icon='rico-icon rico-calarrow' />\r
+ <Rico:EditCol runat='server' ColName='EmployeeID' heading='Emp#' width='60' EntryType='B' ColData='<auto>' />\r
+ <Rico:EditCol runat='server' ColName='LastName' heading='Last Name' width='100' EntryType='B' />\r
+ <Rico:EditCol runat='server' ColName='FirstName' heading='First Name' width='100' EntryType='B' />\r
+ <Rico:EditCol runat='server' ColName='Title' heading='Title' width='120' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='TitleOfCourtesy' heading='Title (Courtesy)' width='90' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='BirthDate' heading='Birth Date' width='100' datatype='date' EntryType='D' SelectCtl='Cal' />\r
+ <Rico:EditCol runat='server' ColName='HireDate' heading='Hire Date' width='100' datatype='date' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
+ <Rico:EditCol runat='server' ColName='Address' heading='Address' width='100' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='City' heading='City' width='100' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='Region' heading='Region' width='100' EntryType='N' />\r
+ <Rico:EditCol runat='server' ColName='PostalCode' heading='Postal Code' width='100' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='Country' heading='Country' width='100' EntryType='N' />\r
+ <Rico:EditCol runat='server' ColName='HomePhone' heading='Home Phone' width='100' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='Extension' heading='Extension' width='100' EntryType='T' />\r
+ <Rico:EditCol runat='server' ColName='ReportsTo' heading='ReportsTo' width='100' EntryType='SL' id='ReportsTo' />\r
+</Rico:LiveGridEdit>\r
\r
</body>\r
</html>\r