<%@ 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
<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
-\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
</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:LiveGridEdit runat='server' id='emp' TableName='employees' DefaultSort='t.LastName,t.FirstName' menuEvent='click' frozenColumns='2' highlightElem='cursorRow'>\r
+ <Rico:CalendarControl runat='server' id='Cal' icon='rico-icon rico-calarrow' />\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='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:Column runat='server' ColName='ReportsTo' heading='ReportsTo' width='100' EntryType='SL' id='ReportsTo' />\r
+</Rico:LiveGridEdit>\r
\r
</body>\r
</html>\r