16.7.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

Listing 16.7 Handling the DataGrid Update Command
private void DataGrid1_UpdateCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
// stop editing and select item
DataGrid1.EditItemIndex = -1;
DataGrid1.SelectedIndex = e.Item.ItemIndex;
sqlDataAdapter1.Fill( productsDS1 );
// get the row from the database
ProductsDS.ProductsRow row = productsDS1.Products.FindByProductID (
(int)DataGrid1.DataKeys[e.Item.DataSetIndex]);
// set corresponding values from datagrid
row[“ProductName”] = ((TextBox) e.Item.Cells[2].Controls[0]).Text;
row[“QuantityPerUnit”] = ((TextBox) e.Item.Cells[3].Controls[0]).Text;
row[“UnitPrice”] = ((TextBox) e.Item.Cells[4].Controls[0]).Text;
row[“UnitsInStock”]= ((TextBox) e.Item.Cells[5].Controls[0]).Text;
row[“UnitsOnOrder”]= ((TextBox) e.Item.Cells[6].Controls[0]).Text;
row[“Discontinued”]= ((CheckBox) e.Item.Cells[7].Controls[1]).Checked;
// update database and rebind
sqlDataAdapter1.Update( productsDS1 );
DataBind();
}