app.OpenGridForm(ex8)\r
End Sub\r
\r
-Protected Overrides Sub Render(writer as HTMLTextWriter)\r
- select case ex8.action\r
- case "table": MyBase.Render(writer)\r
- case "ins": ex8.InsertRecord(writer)\r
- case "upd": ex8.UpdateRecord(writer)\r
- case "del": ex8.DeleteRecord(writer)\r
- end select\r
-End Sub\r
-\r
</script>\r
\r
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">\r
<Rico:LoadClient checkQueryString='true' runat='server' />\r
<link href="../demo.css" type="text/css" rel="stylesheet" />\r
\r
-<style type="text/css">\r
-div.ricoLG_cell {\r
- white-space:nowrap;\r
-}\r
-</style>\r
</head>\r
\r
\r
<p><strong>Orders Table</strong></p>\r
\r
\r
-<Rico:LiveGridEdit runat='server' id='ex8' TableName='orders' DefaultSort='OrderID' FilterLocation='-1'>\r
+<Rico:LiveGridEdit runat='server' id='ex8' DefaultSort='OrderID' FilterLocation='-1'>\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
+\r
+ <Rico:Table runat='server' TblName='orders' />\r
<Rico:ColumnGroup 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='m' 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
+ <Rico:EditCol runat='server' heading='Order#' width='60' ColName='OrderID' EntryType='B' ColData='<auto>' ConfirmDeleteColumn='true' />\r
+ <Rico:EditCol 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:EditCol runat='server' heading='Sales Person' width='140' ColName='EmployeeID' EntryType='SL' filterUI='m' id='EmployeeID' />\r
+ <Rico:EditCol runat='server' heading='Order Date' width='100' ColName='OrderDate' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
+ <Rico:EditCol runat='server' heading='Required Date' width='100' ColName='RequiredDate' EntryType='D' ColData='Today' SelectCtl='Cal' />\r
+ <Rico:FormulaCol runat='server' heading='Net Sale' width='80' DataType='DOLLAR' Formula='select sum(UnitPrice*Quantity*(1.0-Discount)) from order_details d where d.OrderID=t.OrderID' />\r
\r
<Rico:ColumnGroup runat='server' heading='Ship To' />\r
- <Rico:Column runat='server' heading='Name' width='150' ColName='ShipName' EntryType='B' />\r
- <Rico:Column runat='server' heading='Address' width='150' ColName='ShipAddress' EntryType='B' />\r
- <Rico:Column runat='server' heading='City' width='120' ColName='ShipCity' EntryType='B' filterUI='m' />\r
- <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
+ <Rico:EditCol runat='server' heading='Name' width='150' ColName='ShipName' EntryType='B' />\r
+ <Rico:EditCol runat='server' heading='Address' width='150' ColName='ShipAddress' EntryType='B' />\r
+ <Rico:EditCol runat='server' heading='City' width='120' ColName='ShipCity' EntryType='B' filterUI='m' />\r
+ <Rico:EditCol runat='server' heading='Region' width='80' ColName='ShipRegion' EntryType='T' />\r
+ <Rico:EditCol runat='server' heading='Postal Code' width='80' ColName='ShipPostalCode' EntryType='T' />\r
+ <Rico:EditCol 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
</Rico:LiveGridEdit>\r
\r
</body>\r