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