在ASP.NET 2.0中操作數(shù)據(jù)之五十一：從GridView的頁腳插入新記錄

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;
}