private void InterfacesGrid_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { if (e.ColumnIndex != 8) { return; } System.Windows.Forms.DataGridView CC; CC = (System.Windows.Forms.DataGridView)sender; //Okay, Bring Up Startup Info SingleMultiLineInputForm InterfaceSingleMultiLineInputForm = new SingleMultiLineInputForm("Startup Information", "Serial Number", CC.CurrentCell.FormattedValue.ToString()); InterfaceSingleMultiLineInputForm.ShowDialog(); // InterfacesGrid.CancelEdit(); if (InterfaceSingleMultiLineInputForm.Saved) { CC.CurrentCell.Value = InterfaceSingleMultiLineInputForm.Result; SaveAndContinue.Enabled = true; SaveAndExit.Enabled = true; toolStripButton9.Text = "Cancel Changes"; } SetColumnIndex method = new SetColumnIndex(Mymethod); InterfacesGrid.BeginInvoke(method, 9); }
private void FillGrid() { LoadingGrid = true; InterfacesGrid.DataSource = null; InterfacesGrid.Columns.Clear(); SQLiteDataAdapter LBea1; DataSet LBdes1; SQLiteConnection LBen1; string LeBSQL1; SQLiteCommand LBecmd1; DataTable LBeet1; LBen1 = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); LBen1.SetPassword(Password); LBen1.Open(); LeBSQL1 = "Select * from InterfaceTypes order by Description"; LBecmd1 = new SQLiteCommand(LeBSQL1, LBen1); LBea1 = new SQLiteDataAdapter(LBecmd1); LBdes1 = new DataSet(); LBea1.Fill(LBdes1); LBeet1 = LBdes1.Tables[0]; SQLiteDataAdapter LBea2; DataSet LBdes2; SQLiteConnection LBen2; string LeBSQL2; SQLiteCommand LBecmd2; DataTable LBeet2; LBen2 = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); LBen2.SetPassword(Password); LBen2.Open(); LeBSQL2 = "Select * from Rooms order by RoomName"; LBecmd2 = new SQLiteCommand(LeBSQL2, LBen2); LBea2 = new SQLiteDataAdapter(LBecmd2); LBdes2 = new DataSet(); LBea2.Fill(LBdes2); LBeet2 = LBdes2.Tables[0]; SQLiteDataAdapter LBea3; DataSet LBdes3; SQLiteConnection LBen3; string LeBSQL3; SQLiteCommand LBecmd3; DataTable LBeet3; LBen3 = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); LBen3.SetPassword(Password); LBen3.Open(); LeBSQL3 = "Select * from PluginReference order by FileName"; LBecmd3 = new SQLiteCommand(LeBSQL3, LBen3); LBea3 = new SQLiteDataAdapter(LBecmd3); LBdes3 = new DataSet(); LBea3.Fill(LBdes3); LBeet3 = LBdes3.Tables[0]; LBeet3.Rows.Add(""); LBeet3.AcceptChanges(); SQLiteDataAdapter LBea4; DataSet LBdes4; SQLiteConnection LBen4; string LeBSQL4; SQLiteCommand LBecmd4; DataTable LBeet4; LBen4 = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); LBen4.SetPassword(Password); LBen4.Open(); LeBSQL4 = "Select * from Interfaces order by InterfaceName"; LBecmd4 = new SQLiteCommand(LeBSQL4, LBen4); LBea4 = new SQLiteDataAdapter(LBecmd4); LBdes4 = new DataSet(); LBea4.Fill(LBdes4); LBeet4 = LBdes4.Tables[0]; SQLiteDataAdapter LBea5; DataSet LBdes5; SQLiteConnection LBen5; string LeBSQL5; SQLiteCommand LBecmd5; DataTable LBeet5; LBen5 = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); LBen5.SetPassword(Password); LBen5.Open(); LeBSQL5 = "Select * from PluginReference order by FileName"; LBecmd5 = new SQLiteCommand(LeBSQL5, LBen5); LBea5 = new SQLiteDataAdapter(LBecmd5); LBdes5 = new DataSet(); LBea5.Fill(LBdes5); LBeet5 = LBdes5.Tables[0]; LBeet5.Rows.Add(""); LBeet5.AcceptChanges(); cn = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); cn.SetPassword(Password); cn.Open(); string SQL; SQL = "SELECT * FROM Interfaces"; SQLiteCommand cmd = new SQLiteCommand(SQL, cn); da = new SQLiteDataAdapter(cmd); ds = new DataSet(); try { da.Fill(ds); DataTable dt = ds.Tables[0]; bindingSource1.DataSource = dt; InterfacesNavigator.BindingSource = bindingSource1; InterfacesGrid.DataSource = bindingSource1; InterfacesGrid.AutoGenerateColumns = true; InterfacesGrid.Columns[0].Visible = false; InterfacesGrid.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { Close(); } sqCommandBuilder = new SQLiteCommandBuilder(da); DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn(); col.DataPropertyName = "RoomUniqueID"; col.HeaderText = "Room"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[2].Visible = false; col.DataSource = LBeet2; col.ValueMember = "UniqueID"; col.DisplayMember = "RoomName"; col.Name = col.HeaderText; col.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; col.Resizable = DataGridViewTriState.True; InterfacesGrid.Columns.Add(col); DataGridViewComboBoxColumn col1 = new DataGridViewComboBoxColumn(); col1.DataPropertyName = "InterfaceType"; col1.HeaderText = "InterfaceType"; col1.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[3].Visible = false; col1.DataSource = LBeet1; col1.ValueMember = "Code"; col1.DisplayMember = "Description"; col1.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; col1.Resizable = DataGridViewTriState.True; col1.Name = col1.HeaderText; InterfacesGrid.Columns.Add(col1); DataGridViewComboBoxColumn col2 = new DataGridViewComboBoxColumn(); col2.DataPropertyName = "PluginName"; col2.HeaderText = "Plugin Name"; col2.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[7].Visible = false; col2.DataSource = LBeet3; col2.ValueMember = "FileName"; col2.DisplayMember = "FileName"; col2.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; col2.Resizable = DataGridViewTriState.True; col2.Name = col2.HeaderText; InterfacesGrid.Columns.Add(col2); DataGridViewComboBoxColumn col3 = new DataGridViewComboBoxColumn(); col3.DataPropertyName = "InterfaceUniqueID"; col3.HeaderText = "Interface Connection"; col3.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[6].Visible = false; col3.DataSource = LBeet4; col3.ValueMember = "UniqueID"; col3.DisplayMember = "InterfaceName"; col3.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; col3.Resizable = DataGridViewTriState.True; col3.Name = col3.HeaderText; InterfacesGrid.Columns.Add(col3); DataGridViewComboBoxColumn col4 = new DataGridViewComboBoxColumn(); col4.DataPropertyName = "ControllingDLL"; col4.HeaderText = "DLL Contolling Data"; col4.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; InterfacesGrid.Columns[9].Visible = false; col4.DataSource = LBeet5; col4.ValueMember = "FileName"; col4.DisplayMember = "FileName"; col4.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; col4.Resizable = DataGridViewTriState.True; col4.Name = col4.HeaderText; InterfacesGrid.Columns.Add(col4); InterfacesGrid.Columns[0].DisplayIndex = 14; InterfacesGrid.Columns[2].DisplayIndex = 14; InterfacesGrid.Columns[3].DisplayIndex = 14; InterfacesGrid.Columns[6].DisplayIndex = 14; InterfacesGrid.Columns[7].DisplayIndex = 14; InterfacesGrid.Columns[1].DisplayIndex = 0; InterfacesGrid.Columns[11].DisplayIndex = 1; InterfacesGrid.Columns[14].DisplayIndex = 2; InterfacesGrid.Columns[13].DisplayIndex = 3; InterfacesGrid.Columns[4].DisplayIndex = 4; InterfacesGrid.Columns[5].DisplayIndex = 5; InterfacesGrid.Columns[8].DisplayIndex = 6; InterfacesGrid.Columns[12].DisplayIndex = 7; InterfacesGrid.Columns[9].DisplayIndex = 8; InterfacesGrid.Columns[10].DisplayIndex = 9; for (int i = 0; i < InterfacesGrid.ColumnCount; i++) { InterfacesGrid.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic; } InterfacesGrid.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); if (InterfacesGrid.SortedColumn == null) { InterfacesGrid.Sort(InterfacesGrid.Columns[1], ListSortDirection.Ascending); } else { if (InterfacesGrid.SortOrder == SortOrder.Ascending) { InterfacesGrid.Sort(InterfacesGrid.SortedColumn, ListSortDirection.Ascending); } else { InterfacesGrid.Sort(InterfacesGrid.SortedColumn, ListSortDirection.Descending); } } LoadingGrid = false; SaveAndContinue.Enabled = false; SaveAndExit.Enabled = false; toolStripButton9.Text = "Exit"; }
private void Mymethod(int columnIndex) { InterfacesGrid.CurrentCell = InterfacesGrid.CurrentRow.Cells[columnIndex]; InterfacesGrid.Focus(); }
private void Save_Click(object sender, EventArgs e) { int i = 1; InterfacesGrid.EndEdit(); try { i = InterfacesGrid.CurrentCell.RowIndex; } catch (Exception ex) { } try { InterfacesGrid.EndEdit(); if (InterfacesGrid.RowCount == 1) { InterfacesGrid.CurrentCell = InterfacesGrid[1, 0]; bindingNavigatorAddNewItem1.PerformClick(); InterfacesGrid.CurrentCell = InterfacesGrid[1, 1]; bindingSource1.RemoveCurrent(); InterfacesGrid.CurrentCell = InterfacesGrid[1, 0]; } else { if (i > 1) { InterfacesGrid.CurrentCell = InterfacesGrid[1, i - 1]; } else { InterfacesGrid.CurrentCell = InterfacesGrid[1, 0]; InterfacesGrid.CurrentCell = InterfacesGrid[1, 1]; InterfacesGrid.CurrentCell = InterfacesGrid[1, 0]; } InterfacesGrid.CurrentCell = InterfacesGrid[1, i]; } } catch (Exception ex) { } try { LoadingGrid = true; InterfacesGrid.EndEdit(); da.Update(ds.Tables[0]); ds.Tables[0].AcceptChanges(); FillGrid(); LoadingGrid = false; } catch (Exception ex) { } System.Windows.Forms.ToolStripButton B = (System.Windows.Forms.ToolStripButton)sender; if ((B.Name == "SaveAndExit")) { Close(); } }