private void PopulateGrid() { DataTable dt = new DataTable(); dt = IncentiveDL.SelectIncGen(); grdIncDet.DataSource = dt; grdIncDetView.PopulateColumns(); grdIncDetView.Columns["IncentiveId"].Visible = false; grdIncDetView.Columns["Narration"].Visible = false; grdIncDetView.Columns["TotalAmount"].Visible = false; grdIncDetView.Columns["IDate"].Caption = "Date"; grdIncDetView.Columns["FDate"].Caption = "From Date"; grdIncDetView.Columns["TDate"].Caption = "To Date"; grdIncDetView.Columns["IRefNo"].Caption = "Reference No"; }
private void EditIncGen() { btnGenerate.Enabled = false; DataTable dt = new DataTable(); dt_IncGen = new DataTable(); dt_IncGenTrans = new DataTable(); dt_IncGen = IncentiveDL.SelectIncGen(); using (DataView dv = new DataView(dt_IncGen) { RowFilter = String.Format("IncentiveId={0}", i_mId) }) { dt_IncGen = dv.ToTable(); if (dt_IncGen.Rows.Count > 0) { IncGenBO.i_IncGenId = i_mId; DEDate.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["IDate"].ToString()); DEFrom.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["FDate"].ToString()); DETo.EditValue = Convert.ToDateTime(dt_IncGen.Rows[0]["TDate"].ToString()); txtRefNo.Text = dt_IncGen.Rows[0]["IRefNo"].ToString(); txtNarration.Text = dt_IncGen.Rows[0]["Narration"].ToString(); dt_IncGenTrans = IncentiveDL.SelectIncGenTrans(IncGenBO); if (dt_IncGenTrans.Rows.Count > 0) { dt = (grdIG.DataSource) as DataTable; for (int i = 0; i <= dt_IncGenTrans.Rows.Count - 1; i++) { grdIGView.SetRowCellValue(i, grdIGView.Columns["Amount"].ToString(), dt_IncGenTrans.Rows[i]["Amount"].ToString()); } } } } grdIGView.UpdateSummary(); }
public static DataTable SelectIncGen() { return(IncentiveDL.SelectIncGen()); }