protected void CapexGridApproval_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedQty"], "ApprovedQtyCapex") as ASPxTextBox; ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedCost"], "ApprovedCostCapex") as ASPxTextBox; ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedTotalCost"], "ApprovedTotalCostCapex") as ASPxTextBox; string PK = e.Keys[0].ToString(); Double qty_float = Convert.ToDouble(qty.Value.ToString()); Double cost_float = Convert.ToDouble(cost.Value.ToString()); Double total_float = Convert.ToDouble(total.Value.ToString()); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string update = "UPDATE " + MRPClass.CapexTable() + " SET [ApprovedQty] = @QTY, [ApprovedCost] = @COST, [ApprovedTotalCost] = @TOTAL WHERE [PK] = @PK"; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@QTY", qty_float); cmd.Parameters.AddWithValue("@COST", cost_float); cmd.Parameters.AddWithValue("@TOTAL", total_float); cmd.CommandType = CommandType.Text; int result = cmd.ExecuteNonQuery(); if (result > 0) { MRPClass.UpdateLastModified(conn, docnumber); string remarks = MRPClass.capex_logs + "-" + MRPClass.edit_logs; MRPClass.AddLogsMOPList(conn, mrp_key, remarks); } conn.Close(); e.Cancel = true; grid.CancelEdit(); bindCapex = true; BindCapex(docnumber); }