void DoBatchUpdate() { InvoiceItemsProvider provider = new InvoiceItemsProvider(); foreach (InvoiceItem item in provider.GetItems()) { //!!! do database update here !!! } }
protected void Page_Load(object sender, EventArgs e) { //Populate grid with data on the first load if (!IsPostBack && !IsCallback) { InvoiceItemsProvider provider = new InvoiceItemsProvider(); provider.Populate(); } }
void UpdateItem(int id, bool value) { //Update your data here InvoiceItemsProvider provider = new InvoiceItemsProvider(); InvoiceItem item = provider.GetItemById(id); if (item != null) { item.IsPaid = value; } }
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { InvoiceItemsProvider provider = new InvoiceItemsProvider(); InvoiceItem item = provider.GetItemById((int)e.Keys[0]); if (item != null) { item.Name = Convert.ToString(e.NewValues["Name"]); item.Price = Convert.ToDecimal(e.NewValues["Price"]); item.Quantity = Convert.ToInt32(e.NewValues["Quantity"]); } //Cancel automatic update e.Cancel = true; //back to the browse mode ((ASPxGridView)sender).CancelEdit(); }