dbSelectedItemMacro Property

Define SelecetdItem setup parameters.

Product Version

All

[Visual Basic]
Public Property dbSelectedItemMacro As String

[C#]
public string dbSelectedItemMacro {set;}

Property Value

Obj.dbSelectedItemMacro = "(;,[]!|~/+{})Macro|QTYCol|Caption|Size|Buttons|Images|Raw, ...Repeat

Keyword	Description
(;,[]!\|~/+{})	Same delimiter string as MagicCell
Macro	Export macro string with embedded fields.
QTYCol	True(Def)\|False. Qty column next to CheckBox.
Caption	Caption for QtyCol. Def="Qty"
Size	SIZE of the input box. Def=5
Buttons	True\|False. Show the Clear All (c) and Check All (x) buttons.
Images	Button Image file
Raw	True\|False(Def). Strip all the HTML tags off the Macro upon return. This is needed when you want to extract a colored number and need to use it as a number for calculation w/o the HTML tags around it.

QuickProp Keyword Abbreviation

sim

Remarks

Example

See dbSelectedItem for a 1-Dim example.

The following is a 1-Dim example retriving 'SelectedItems' only.

Remember to Click 'Sel' button to register selections.
Page forth and back and add/delete selections.
Query a DB and display the Grid (Master) and the Form (Detail) with field #0 as index
Setup a user selection system using check boxes in every row
Setup come convenient aids (buttons) for users to select and clear items
Allow user to page forth and back to select or de-select items w/o losing track of the selection.
Display how many items are marked in the status line as an indicator
Allow user to define how the selection output will be formatted via a macro
Process this macro through the MagicCell filter (see the output format of the Product ID field)
Present the result as an array for easy processing
This example looks simple because it has not too many lines of code, but it actually illustrates the rich features of the very powerful ASP-db.Net.

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim GD As New Tornado.GetData
  Dim Sitem1 As New Tornado.z
  With Sitem1
    .dbQP = "U=5| S=10| M=ty=dh!sys=f!ind=0| D=Nwind| Q=Products|" & _
      " Gdf=0,1| Ps=10| Th=Ti=1D SelectItems Demo"
    .dbNameMap = "field=0|alias=Product<br>ID"
    .dbSelectedItemMacro = "(;,[]!|~/+{})macro=!0:0##! - !1!" & _
      " (!UnitsInStock!)|qtycol=false|buttons=true"
    .ASPdbNET()

'--- User Code to process Selected Items ---

    If GD.Get_SelectedItem <> Nothing Then
      Dim i As Integer
      Dim Res As String = "<P><center><table class=ts cellspacing='1'>" & _
        "<tr><th class='GH'>Selected Items According to Macro</th></tr>" & _
        "<tr><td class='R2'>"
      Dim a() As String = .dbSelectedItem()
      If a Is Nothing Then
        Res &= "No selection"
      Else
        For i = 0 To UBound(a)
            Res &= a(i) & "<br>"
        Next i
      End If
      Response.Write(Res & "</table></center>")
    End If
End With
End Sub
</script>

z.dbSelectedItemMacro Property

Product Version

Property Value

QuickProp Keyword Abbreviation

Remarks

Example

See Also