/// <summary> /// Populating the datagrid and /// retrieving the next journal /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void JournalAdd_Load(object sender, EventArgs e) { DataTable dt = SubGroup.ViewSubGroup(); /////////////////////////////////// //// Account name DataGridViewComboBoxColumn cw = new DataGridViewComboBoxColumn(); cw.DataSource = dt; cw.DisplayMember = "S_DESC"; cw.HeaderText = "ACCOUNT NAME"; this.JournalGridView.Columns.Add(cw); /////////////////////////////////////// ////// debit or Credit ////// DataTable myDataTable = new DataTable(); DataColumn myDataColumn; myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "Account"; myDataColumn.ReadOnly = false; myDataColumn.Unique = true; myDataTable.Columns.Add(myDataColumn); DataRow dr = myDataTable.NewRow(); dr["Account"] = "DR"; myDataTable.Rows.Add(dr); myDataTable.AcceptChanges(); dr = myDataTable.NewRow(); dr["Account"] = "CR"; myDataTable.Rows.Add(dr); myDataTable.AcceptChanges(); cw = new DataGridViewComboBoxColumn(); cw.DataSource = myDataTable; cw.DisplayMember = "Account"; this.JournalGridView.Columns.Add(cw); ////////////////////////////////////// //// Amount Column //// DataGridViewTextBoxColumn ct = new DataGridViewTextBoxColumn(); this.JournalGridView.Columns.Add(ct); /////////////////////////////////////// ///// Retrieve next journal id ///// int rst = JournalPoster.NextJournal(); this.journalidtxt.Text = rst.ToString(); }
private void button2_Click(object sender, EventArgs e) { int x = JournalPoster.NextJournal(); MessageBox.Show(x.ToString()); }