public void RefreshRowDataGridDetail(Guid RowID_) { DataTable dt = new DataTable(); DataTable dtRefresh; using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_CF_RencanaPembayaranHutangDetail_List")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_)); dtRefresh = db.Commands[0].ExecuteDataTable(); } if (dtRefresh.Rows.Count > 0) { GVRencana.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID_.ToString()); GVRencana.FindRow("RowID3", RowID_.ToString()); dtD.AcceptChanges(); DataRowView dv = (DataRowView)GVPL.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.BeginEdit(); dr["SaldoUSD"] = Convert.ToDouble(dr["NominalUSD"]) - Convert.ToDouble(dtD.Compute("SUM(USDNominal)", "")); dr["SaldoIDR"] = Convert.ToDouble(dr["NominalIDR"]) - Convert.ToDouble(dtD.Compute("SUM(IDRNominal)", "")); GVPL.SelectedCells[0].OwningRow.Cells["SaldoUSD"].Value = dr["SaldoUSD"]; GVPL.SelectedCells[0].OwningRow.Cells["SaldoIDR"].Value = dr["SaldoIDR"]; dr.EndEdit(); dr.AcceptChanges(); dtH.AcceptChanges(); GVPL.RefreshEdit(); } }
public void RefreshRowDataGridDetail(Guid RowID_) { DataTable dt = new DataTable(); DataTable dtRefresh; using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_CF_RencanaGlobal_Detail")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_)); dtRefresh = db.Commands[0].ExecuteDataTable(); } if (dtRefresh.Rows.Count > 0) { GVRencana.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID_.ToString()); GVRencana.FindRow("RowID3", RowID_.ToString()); dtD.AcceptChanges(); } }