public void HeaderRefresh() { _fromDate = (DateTime)rdBKM.FromDate; _toDate = (DateTime)rdBKM.ToDate; try { this.Cursor = Cursors.WaitCursor; dtBKM = new DataTable(); // using (Database db = new Database("ISADBDepoFinance")) using (Database db = new Database(GlobalVar.DBFinance)) { dtBKM = BKM.ListHeader(db, _fromDate, _toDate); } //DataColumn cNoDOAndFlag = new DataColumn("NoDOAndFlag", Type.GetType("System.String")); //cNoDOAndFlag.Expression = "NoDO + ' ' + FlagDO"; //dtDO.Columns.Add(cNoDOAndFlag); dtBKM.DefaultView.Sort = "TglBukti, Pos, NoBukti"; dgHeaderBKM.DataSource = dtBKM.DefaultView; if (dgHeaderBKM.SelectedCells.Count > 0) { DetailRefresh(); } else { dtBKMDetail.Clear(); dgDetailBKM.DataSource = dtBKMDetail.DefaultView; } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }