private void ListBox_Of_Tallies_Input_MouseUp(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Right) { var item = this.ListBox_Of_Tallies_Input.IndexFromPoint(e.Location); if (item >= 0 && ListBox_Of_Tallies_Input.SelectedIndices.Contains(item) == false) { ListBox_Of_Tallies_Input.ClearSelected(); ListBox_Of_Tallies_Input.SelectedIndex = item; } } }
private void ListBox_Of_Tallies_Input_DoubleClick(object sender, EventArgs e) { List <string> Names_of_Tabs = new List <string>(); TabPage tab = new TabPage(); tab.BackColor = Color.FromArgb(50, 50, 50); tab.BorderStyle = BorderStyle.None; DataView dataView = new DataView(); AdvancedDataGridView advancedDataGridView1 = new AdvancedDataGridView(); advancedDataGridView1.ForeColor = Color.Black; advancedDataGridView1.ReadOnly = true; advancedDataGridView1.BorderStyle = BorderStyle.None; advancedDataGridView1.Dock = DockStyle.Fill; advancedDataGridView1.RowHeadersVisible = false; advancedDataGridView1.EnableHeadersVisualStyles = false; advancedDataGridView1.AllowUserToAddRows = false; advancedDataGridView1.AllowUserToDeleteRows = false; advancedDataGridView1.BorderStyle = BorderStyle.None; advancedDataGridView1.BackgroundColor = Color.FromArgb(50, 50, 50); advancedDataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(79, 129, 189); advancedDataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; advancedDataGridView1.RowsDefaultCellStyle.BackColor = Color.FromArgb(184, 204, 228); advancedDataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(220, 230, 241); advancedDataGridView1.SortStringChanged += AdvancedDataGridView1_SortStringChanged; advancedDataGridView1.FilterStringChanged += AdvancedDataGridView1_FilterStringChanged; if (ListBox_Of_Tallies_Input.Items.Count > 0 && ListBox_Of_Tallies_Input.SelectedItem != null) { string name = ListBox_Of_Tallies_Input.GetItemText(ListBox_Of_Tallies_Input.SelectedItem); for (int i = 0; i < Open_Tally_Input.Tallies_Names.Count; i++) { if (name == Open_Tally_Input.Tallies_Names[i]) { dataView = new DataView(Open_Tally_Input.Tallies[i]); advancedDataGridView1.DataSource = dataView; tab.Text = Open_Tally_Input.Tallies_Names[i]; tab.Controls.Add(advancedDataGridView1); } } for (int i = 0; i < Open_Tally_Input.Excels_Names.Count; i++) { if (name == Open_Tally_Input.Excels_Names[i]) { dataView = new DataView(Open_Tally_Input.Excels[i]); advancedDataGridView1.DataSource = dataView; tab.Text = Open_Tally_Input.Excels_Names[i]; tab.Controls.Add(advancedDataGridView1); } } for (int i = 0; i < tabControl1.TabPages.Count; i++) { Names_of_Tabs.Add(tabControl1.TabPages[i].Text); } if (!Names_of_Tabs.Contains(tab.Text) && advancedDataGridView1 != null) { tabControl1.TabPages.Add(tab); tabControl1.Visible = true; } int AllRows = 0; for (int j = 0; j < advancedDataGridView1.ColumnCount; j++) { if (advancedDataGridView1.Rows.Count > 1) { if (advancedDataGridView1.Columns[j].Name == "GroupCount" || advancedDataGridView1.Columns[j].Name == "\"GroupCount\"") { for (int k = 0; k < advancedDataGridView1.Rows.Count; k++) { AllRows += Convert.ToInt32(advancedDataGridView1.Rows[k].Cells[j].Value); } } } } var row = dataView.Table.Rows[dataView.Table.Rows.Count - 1]; if (AllRows > 0) { if (row[0].ToString() != "TOTAL") { foreach (DataColumn dc in dataView.Table.Columns) { if (dc.ColumnName == "\"GroupCount\"") { DataRowView drToAdd = dataView.AddNew(); drToAdd[0] = "TOTAL"; drToAdd["\"GroupCount\""] = AllRows; drToAdd.EndEdit(); } if (dc.ColumnName == "GroupCount") { DataRowView drToAdd = dataView.AddNew(); drToAdd[0] = "TOTAL"; drToAdd["GroupCount"] = AllRows; drToAdd.EndEdit(); } } } } var row2 = dataView.Table.Rows[dataView.Table.Rows.Count - 1]; if (advancedDataGridView1.RowCount > 1 && row2[0].ToString() == "TOTAL") { advancedDataGridView1.Rows[advancedDataGridView1.RowCount - 1].DefaultCellStyle.BackColor = Color.FromArgb(79, 129, 189); advancedDataGridView1.Rows[advancedDataGridView1.RowCount - 1].DefaultCellStyle.ForeColor = Color.White; } advancedDataGridView1.ClearSelection(); } }