grocery-lookup1.axpx Source Code

grocery-lookup1.aspx Source Code

<%@ Page Language="C#" %>
<%@ Import Namespace="System.IO" %>

public void ddlUPC_SelectedIndexChanged(object sender, EventArgs e)
{
      int codeToFind = int.Parse(ddlUPC.SelectedValue);
      string line, item, onSale;
      string[ ] fields;
      int code, quantity;
      double price;
      
      StreamReader sr = new System.IO.StreamReader(
          e:/ectserver/sjost/Database/groceries.csv);
      while(sr.Peek( ) > -1)
      {
          line = sr.ReadLine( );
          fields = line.Split(',');
          code = int.Parse(fields[1]);
          if(codeToFind == code)
          {
              // Copy other fields into textboxes.
              item = fields[0];
              txtItem.Text = item;
              quantity = int.Parse(fields[2]);
              txtQuantity.Text = quantity.ToString( );
              price = double.Parse(fields[3]);
              txtPrice.Text = price.ToString(#0.00);
              onSale = fields[4];
              if (onSale == 1)
              {
                  txtOnSale.Text = On Sale;
              }
              else
              {
                  txtOnSale.Text = Not on Sale;
              }
              sr.Close( );
              return;
          }
      }
      txtItem.Text = N/A;
      txtQuantity.Text = N/A;
      txtPrice.Text = N/A;
      txtOnSale.Text = N/A;
    
      sr.Close( );
}

</script>

<html>

<head>
<title>grocery-lookup1.aspx Example</title>
<link rel=stylesheet type=text/css 
                       href=examples.css />
<style type=text/css>
td  { padding-left:0.15cm;
      padding-right:0.15cm;
      padding-top:0.15cm;
      padding-bottom:0.15cm; }
</style>
</head>

<body>

<h2>grocery-lookup1.aspx Example</h2>

<h2>Select UPC for information on grocery item.</h2>

<p>Look up information in the groceries.csv file by UPC code.</p>

<table>

<tr>
    <td style=text-align:right>UPC</td> 
    <td><asp:DropDownList runat=server
             AutoPostback=true
             ID=ddlUPC 
             OnSelectedIndexChanged=
                 ddlUPC_SelectedIndexChanged
             style=width: 1.5in; font-family:Verdana;
                    font-size:100%; >
        </asp:DropDownList>
</tr>
<tr>
    <td style=text-align:right>Item</td> 
    <td><asp:TextBox runat=server
             ID=txtItem 
             Text=
             style=width: 1.5in /></td>
</tr>
<tr>
    <td style=text-align:right>Quantity</td> 
    <td><asp:TextBox runat=server
             ID=txtQuantity 
             Text=
             style=width: 1.5in /></td>
</tr>
<tr>
    <td style=text-align:right>Price</td> 
    <td><asp:TextBox runat=server
             ID=txtPrice 
             Text=
             style=width: 1.5in /></td>
</tr>
<tr>
    <td style=text-align:right>On Sale</td> 
    <td><asp:TextBox runat=server
             ID=txtOnSale 
             Text=
             style=width: 1.5in /></td>
</tr>
</table>
</form>

</body>
</html>