asp.net.ph Source Code Viewer

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
<head>
<title>ButtonField ButtonType Example</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<style type="text/css">
<!--
   .add {
      background:navy; color:lime}
   .remove {
      background:maroon; color:gold}
-->
</style>

<script language="C#" runat="server" src="fetchData_sql.cs" />

<script language="C#" runat="server">
   DataTable Cart;
   DataView CartView;

   void Page_Load ( Object src, EventArgs e ) {
      if ( !IsPostBack ) {
         string query = "SELECT * FROM Titles where Price > 0";
         myGrid.DataSource = fetchReader ( query );
         myGrid.DataBind ( );
      }

      if ( Session [ "shoppingSession" ] == null ) {
         Cart = new DataTable ( );
         Cart.Columns.Add ( new DataColumn ( "Item", typeof ( string ) ) );
         Cart.Columns.Add ( new DataColumn ( "Price", typeof ( string ) ) );
         Session [ "shoppingSession" ] = Cart;
      }
      else Cart = ( DataTable ) Session [ "shoppingSession" ];

      CartView = new DataView ( Cart );
      shopCart.DataSource = CartView;
      shopCart.DataBind ( );
   }

   void updateCart ( Object src, GridViewCommandEventArgs e ) {
      DataRow dr = Cart.NewRow ( );

      // get the row index stored in the CommandArgument property
      int index = Convert.ToInt32 ( e.CommandArgument );
 
      // get the GridViewRow where the command is raised
      GridViewRow selectedRow = ( ( GridView ) e.CommandSource ).Rows [ index ];

      // for bound fields, values are stored in the Text property of Cells [ fieldIndex ]
      string item = selectedRow.Cells [ 1 ].Text;
      string price = selectedRow.Cells [ 2 ].Text;

      if ( e.CommandName == "AddToCart" ) {
         dr [ 0 ] = item; dr [ 1 ] = price;
         Cart.Rows.Add ( dr );
      }
      else {  // remove from Cart
         CartView.RowFilter = "Item='" + item + "'";
         if ( CartView.Count > 0 ) CartView.Delete ( 0 );
         CartView.RowFilter = "";
      }
      shopCart.DataBind ( );
   }

   void setButtonStyle ( Object src, GridViewRowEventArgs e ) {
      if ( e.Row.RowType == DataControlRowType.DataRow ) {
         IDataRecord rowView = ( IDataRecord ) e.Row.DataItem;
         TableCellCollection cells = e.Row.Cells;
         ( ( Button ) cells [ 3 ].Controls [ 0 ] ).CssClass = "add";
         ( ( Button ) cells [ 4 ].Controls [ 0 ] ).CssClass = "remove";
      }
   }
</script>
</head>

<body>
<!-- #include virtual="~/shared/top.inc" -->
<div class="header"><h2>ButtonField <b>ButtonType</b> Example</h2></div>
<hr size=1 width=92%>

<form runat="server">
<table cellpadding="5">
<tr valign="top">
   <td><b>Product List</b>

      <asp:gridview id="myGrid" runat="server"
         cellpadding=5 font-size="9pt"
         gridlines="horizontal"
         autogeneratecolumns=false
         onRowCreated="setButtonStyle"
         onRowCommand="updateCart">

         <headerstyle backcolor="darkslategray"
            forecolor="khaki" font-bold />

         <rowstyle backcolor="ivory" verticalalign="top" />

         <columns>

            <asp:boundfield
               headertext="Title"
               datafield="title" />

            <asp:boundfield
               headertext="Item"
               datafield="title_id" />

            <asp:boundfield
               headertext="Price"
               datafield="price"
               dataformatstring="{0:c}"
               itemstyle-horizontalalign="right" />

            <asp:buttonfield
               text=" + "
               buttontype="button"
               commandname="AddToCart"  />

            <asp:buttonfield
               text=" - "
               buttontype="button"
               commandname="RemoveFromCart" />

         </columns>

      </asp:gridview>
   </td>

   <td><b>Shopping Cart</b>

      <asp:gridview id="shopCart" runat="server"
         cellpadding=5 font-size="9pt"
         headerstyle-backcolor="darkslategray"
         headerstyle-forecolor="khaki"
         headerstyle-font-bold
         rowstyle-backcolor="ivory"
         rowstyle-verticalalign="top" />

   </td></tr>
</table>

</form>

<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->

</body>
</html>