protected void Load_stations() { DataTable dt = new DataTable(); dt = LegacyReports.LoadBranches("select_station_list"); DataRow emptyRow = dt.NewRow(); emptyRow["branch"] = "All"; emptyRow["accounts_code"] = "-1"; dt.Rows.InsertAt(emptyRow, 0); cboBranch.DataSource = dt; cboBranch.DisplayMember = "branch"; cboBranch.ValueMember = "accounts_code"; DataTable _dt = new DataTable(); _dt = LegacyReports.LoadBranches("select_station_list"); DataRow _emptyRow = _dt.NewRow(); _emptyRow["branch"] = "select one"; _emptyRow["accounts_code"] = "-1"; _dt.Rows.InsertAt(_emptyRow, 0); cbostation.DataSource = _dt; cbostation.DisplayMember = "branch"; cbostation.ValueMember = "accounts_code"; }
protected void LoadRecords() { dt = LegacyReports.LoadLegacyAccountEntries("select_legacy_transaction_entries", Convert.ToInt32(cboYear.Text)); gdvList.DataSource = dt; gdvList.Columns["dat"].HeaderText = "Date"; gdvList.Columns["tref"].HeaderText = "Reference Number"; gdvList.Columns["chq"].HeaderText = "Cheque Number"; gdvList.Columns["payee"].HeaderText = "Payee"; gdvList.Columns["dcode"].HeaderText = "Debit Account code"; gdvList.Columns["dtitle"].HeaderText = "Debit Account Title"; gdvList.Columns["ccode"].HeaderText = "Credit Account code"; gdvList.Columns["ctitle"].HeaderText = "Credit Account Title"; gdvList.Columns["sub"].HeaderText = "Sub-Ledger"; gdvList.Columns["amt"].HeaderText = "Amount"; gdvList.RowsDefaultCellStyle.BackColor = Color.LightGray; gdvList.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige; gdvList.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; gdvList.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; gdvList.RowHeadersDefaultCellStyle.BackColor = Color.Black; gdvList.DefaultCellStyle.SelectionBackColor = Color.Cyan; gdvList.DefaultCellStyle.SelectionForeColor = Color.Black; foreach (DataGridViewColumn c in this.gdvList.Columns) { c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 12f, GraphicsUnit.Pixel); } this.gdvList.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue; this.gdvList.EnableHeadersVisualStyles = false; }
private void cbostation_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = LegacyReports.LoadClients("select_client_list", cbostation.SelectedValue.ToString()); DataRow emptyRow = dt.NewRow(); emptyRow["stitle"] = "All"; emptyRow["scode"] = "-1"; dt.Rows.InsertAt(emptyRow, 0); cboclient.DataSource = dt; cboclient.DisplayMember = "stitle"; cboclient.ValueMember = "scode"; }