jQuery UI Widgets Forums Grid dropdopwnlist using orderdetails.xml

This topic contains 1 reply, has 2 voices, and was last updated by  Dimitar 9 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author

  • sxp
    Participant

    hello

    Can anyone point me to a simple example using the sample xml file orderdetails.xml showing a row of data in the grid(cusomterID, employeeID) with the group “OrderDetail” as a cell columntype of DropDownlist containing ProductID, UnitPrice etc.

    many thanks
    Steven


    Dimitar
    Participant

    Hello Steven,

    Note that each order (sample XML given below) has multiple products associated with it. This means that if you would have each order on a single row, instead of a cell with a single ProductID, you would have a cell with an array of ProductIDs. The same goes for UnitPrice and Quantity. That is why this sample data is more suitable for examples such as Master-Details.

    <Order OrderID="10248">
      <CustomerID>VINET</CustomerID>
      <EmployeeID>5</EmployeeID>
      <OrderDate>1996-07-04T14:25:55</OrderDate>
      <RequiredDate>1996-08-01T06:43:44</RequiredDate>
      <ShippedDate>1996-07-16T04:00:12</ShippedDate>
      <ShipVia>3</ShipVia>
      <Freight>32.3800</Freight>
      <ShipName>Vins et alcools Chevalier</ShipName>
      <ShipAddress>59 rue de l'Abbaye</ShipAddress>
      <ShipCity>Reims</ShipCity>
      <ShipRegion/>
      <ShipPostalCode>51100</ShipPostalCode>
      <ShipCountry>France</ShipCountry>
      <OrderDetails>
        <OrderDetail>
          <ProductID>11</ProductID>
          <UnitPrice>14.0000</UnitPrice>
          <Quantity>12</Quantity>
          <Discount>0</Discount>
        </OrderDetail>
        <OrderDetail>
          <ProductID>42</ProductID>
          <UnitPrice>9.8000</UnitPrice>
          <Quantity>10</Quantity>
          <Discount>0</Discount>
        </OrderDetail>
        <OrderDetail>
          <ProductID>72</ProductID>
          <UnitPrice>34.8000</UnitPrice>
          <Quantity>5</Quantity>
          <Discount>0</Discount>
        </OrderDetail>
      </OrderDetails>
    </Order>

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.