<asp:GridView ID="Products" runat="server" AutoGenerateColumns="False"
 DataKeyNames="ProductID" DataSourceID="ProductsDataSource"
 AllowPaging="True" EnableViewState="False" ShowFooter="True">
 <Columns>
 <asp:TemplateField HeaderText="ProductID" InsertVisible="False"
  SortExpression="ProductID">
  <ItemTemplate>
  <asp:Label ID="Label1" runat="server"
   Text='<%# Bind("ProductID") %>'></asp:Label>
  </ItemTemplate>
  <ItemStyle HorizontalAlign="Center" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Product" SortExpression="ProductName">
  <ItemTemplate>
  <asp:Label ID="Label2" runat="server"
   Text='<%# Bind("ProductName") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:TextBox ID="NewProductName" runat="server"></asp:TextBox>
  <asp:RequiredFieldValidator ID="RequiredFieldValidator1"
   runat="server" ControlToValidate="NewProductName"
   Display="Dynamic" ForeColor=""
   ErrorMessage="You must enter a name for the new product.">
   * </asp:RequiredFieldValidator>
  </FooterTemplate>
  <FooterStyle Wrap="False" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
  <ItemTemplate>
  <asp:Label ID="Label10" runat="server"
   Text='<%# Bind("CategoryName") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:DropDownList ID="NewCategoryID" runat="server"
   DataSourceID="CategoriesDataSource"
   DataTextField="CategoryName" DataValueField="CategoryID">
  </asp:DropDownList>
  <asp:ObjectDataSource ID="CategoriesDataSource" runat="server"
   OldValuesParameterFormatString="original_{0}"
   SelectMethod="GetCategories" TypeName="CategoriesBLL">
  </asp:ObjectDataSource>
  </FooterTemplate>
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Supplier" SortExpression="SupplierName">
  <ItemTemplate>
  <asp:Label ID="Label11" runat="server"
   Text='<%# Bind("SupplierName") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:DropDownList ID="NewSupplierID" runat="server"
   DataSourceID="SuppliersDataSource"
   DataTextField="CompanyName" DataValueField="SupplierID">
  </asp:DropDownList><asp:ObjectDataSource ID="SuppliersDataSource"
   runat="server" OldValuesParameterFormatString="original_{0}"
   SelectMethod="GetSuppliers" TypeName="SuppliersBLL">
  </asp:ObjectDataSource>
  </FooterTemplate>
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Qty/Unit" SortExpression="QuantityPerUnit">
  <ItemTemplate>
  <asp:Label ID="Label5" runat="server"
   Text='<%# Bind("QuantityPerUnit") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:TextBox ID="NewQuantityPerUnit" runat="server"></asp:TextBox>
  </FooterTemplate>
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Price" SortExpression="UnitPrice">
  <ItemTemplate>
  <asp:Label ID="Label6" runat="server"
   Text='<%# Bind("UnitPrice", "{0:c}") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  $<asp:TextBox ID="NewUnitPrice" runat="server" Columns="8" />
  <asp:CompareValidator ID="CompareValidator1" runat="server"
   ControlToValidate="NewUnitPrice"
   ErrorMessage="You must enter a valid currency value greater than
   or equal to 0.00. Do not include the currency symbol."
   ForeColor="" Operator="GreaterThanEqual" Type="Currency"
   ValueToCompare="0" Display="Dynamic">
   * </asp:CompareValidator>
  </FooterTemplate>
  <ItemStyle HorizontalAlign="Right" />
  <FooterStyle Wrap="False" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Units In Stock"
  SortExpression="Units In Stock">
  <ItemTemplate>
  <asp:Label ID="Label7" runat="server"
   Text='<%# Bind("UnitsInStock") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:TextBox ID="NewUnitsInStock" runat="server" Columns="5" />
  <asp:CompareValidator ID="CompareValidator2" runat="server"
   ControlToValidate="NewUnitsInStock" Display="Dynamic"
   ErrorMessage="You must enter a valid numeric value for units
   in stock that's greater than or equal to zero."
   ForeColor="" Operator="GreaterThanEqual" Type="Integer"
   ValueToCompare="0">*</asp:CompareValidator>
  </FooterTemplate>
  <ItemStyle HorizontalAlign="Right" />
  <FooterStyle Wrap="False" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Units On Order" SortExpression="UnitsOnOrder">
  <ItemTemplate>
  <asp:Label ID="Label8" runat="server"
   Text='<%# Bind("UnitsOnOrder") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:TextBox ID="NewUnitsOnOrder" runat="server" Columns="5" />
  <asp:CompareValidator ID="CompareValidator3" runat="server"
   ControlToValidate="NewUnitsOnOrder" Display="Dynamic"
   ErrorMessage="You must enter a valid numeric value for units on
   order that's greater than or equal to zero."
   ForeColor="" Operator="GreaterThanEqual" Type="Integer"
   ValueToCompare="0">*</asp:CompareValidator>
  </FooterTemplate>
  <ItemStyle HorizontalAlign="Right" />
  <FooterStyle Wrap="False" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Reorder Level" SortExpression="ReorderLevel">
  <ItemTemplate>
  <asp:Label ID="Label9" runat="server"
   Text='<%# Bind("ReorderLevel") %>'></asp:Label>
  </ItemTemplate>
  <FooterTemplate>
  <asp:TextBox ID="NewReorderLevel" runat="server" Columns="5" />
  <asp:CompareValidator ID="CompareValidator4" runat="server"
   ControlToValidate="NewReorderLevel" Display="Dynamic"
   ErrorMessage="You must enter a valid numeric value for reorder
   level that's greater than or equal to zero."
   ForeColor="" Operator="GreaterThanEqual" Type="Integer"
   ValueToCompare="0">*</asp:CompareValidator>
  </FooterTemplate>
  <ItemStyle HorizontalAlign="Right" />
  <FooterStyle Wrap="False" />
 </asp:TemplateField>
 <asp:TemplateField HeaderText="Discontinued" SortExpression="Discontinued">
  <ItemTemplate>
  <asp:CheckBox ID="CheckBox1" runat="server"
   Checked='<%# Bind("Discontinued") %>' Enabled="false" />
  </ItemTemplate>
  <FooterTemplate>
  <asp:CheckBox ID="NewDiscontinued" runat="server" />
  </FooterTemplate>
  <ItemStyle HorizontalAlign="Center" />
  <FooterStyle HorizontalAlign="Center" />
 </asp:TemplateField>
 </Columns>
</asp:GridView>

protected void Products_RowCommand(object sender, GridViewCommandEventArgs e)
{
 // Insert data if the CommandName == "Insert"
 // and the validation controls indicate valid data...
 if (e.CommandName == "Insert" && Page.IsValid)
 {
 // TODO: Insert new record...
 }
}

protected void Products_RowCommand(object sender, GridViewCommandEventArgs e)
{
 // Insert data if the CommandName == "Insert"
 // and the validation controls indicate valid data...
 if (e.CommandName == "Insert" && Page.IsValid)
 {
 // Insert new record
 ProductsDataSource.Insert();
 }
}

protected void ProductsDataSource_Inserting
 (object sender, ObjectDataSourceMethodEventArgs e)
{
 // Programmatically reference Web controls in the inserting interface...
 TextBox NewProductName =
 (TextBox)Products.FooterRow.FindControl("NewProductName");
 DropDownList NewCategoryID =
 (DropDownList)Products.FooterRow.FindControl("NewCategoryID");
 DropDownList NewSupplierID =
 (DropDownList)Products.FooterRow.FindControl("NewSupplierID");
 TextBox NewQuantityPerUnit =
 (TextBox)Products.FooterRow.FindControl("NewQuantityPerUnit");
 TextBox NewUnitPrice =
 (TextBox)Products.FooterRow.FindControl("NewUnitPrice");
 TextBox NewUnitsInStock =
 (TextBox)Products.FooterRow.FindControl("NewUnitsInStock");
 TextBox NewUnitsOnOrder =
 (TextBox)Products.FooterRow.FindControl("NewUnitsOnOrder");
 TextBox NewReorderLevel =
 (TextBox)Products.FooterRow.FindControl("NewReorderLevel");
 CheckBox NewDiscontinued =
 (CheckBox)Products.FooterRow.FindControl("NewDiscontinued");

 // Set the ObjectDataSource's InsertParameters values...
 e.InputParameters["productName"] = NewProductName.Text;
 
 e.InputParameters["supplierID"] =
 Convert.ToInt32(NewSupplierID.SelectedValue);
 e.InputParameters["categoryID"] =
 Convert.ToInt32(NewCategoryID.SelectedValue);
 
 string quantityPerUnit = null;
 if (!string.IsNullOrEmpty(NewQuantityPerUnit.Text))
 quantityPerUnit = NewQuantityPerUnit.Text;
 e.InputParameters["quantityPerUnit"] = quantityPerUnit;

 decimal? unitPrice = null;
 if (!string.IsNullOrEmpty(NewUnitPrice.Text))
 unitPrice = Convert.ToDecimal(NewUnitPrice.Text);
 e.InputParameters["unitPrice"] = unitPrice;

 short? unitsInStock = null;
 if (!string.IsNullOrEmpty(NewUnitsInStock.Text))
 unitsInStock = Convert.ToInt16(NewUnitsInStock.Text);
 e.InputParameters["unitsInStock"] = unitsInStock;

 short? unitsOnOrder = null;
 if (!string.IsNullOrEmpty(NewUnitsOnOrder.Text))
 unitsOnOrder = Convert.ToInt16(NewUnitsOnOrder.Text);
 e.InputParameters["unitsOnOrder"] = unitsOnOrder;

 short? reorderLevel = null;
 if (!string.IsNullOrEmpty(NewReorderLevel.Text))
 reorderLevel = Convert.ToInt16(NewReorderLevel.Text);
 e.InputParameters["reorderLevel"] = reorderLevel;
 
 e.InputParameters["discontinued"] = NewDiscontinued.Checked;
}

// Indicate that the user needs to be sent to the last page
SendUserToLastPage = true;

protected void Products_DataBound(object sender, EventArgs e)
{
 // Send user to last page of data, if needed
 if (SendUserToLastPage)
 Products.PageIndex = Products.PageCount - 1;
}