private void FillGrid() { LoadingGrid = true; cn = new SQLiteConnection("Data Source=" + FileToUse + "; FailIfMissing=true"); cn.SetPassword(Password); cn.Open(); string SQL; SQL = "SELECT * FROM Rooms"; 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; RoomsNavigator.BindingSource = bindingSource1; RoomsGrid.DataSource = bindingSource1; RoomsGrid.AutoGenerateColumns = true; RoomsGrid.Columns[0].Visible = false; RoomsGrid.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; RoomsGrid.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { Close(); } sqCommandBuilder = new SQLiteCommandBuilder(da); if (RoomsGrid.SortedColumn == null) { // RoomsGrid.Sort(RoomsGrid.Columns[1], ListSortDirection.Ascending); } else { if (RoomsGrid.SortOrder == SortOrder.Ascending) { RoomsGrid.Sort(RoomsGrid.SortedColumn, ListSortDirection.Ascending); } else { RoomsGrid.Sort(RoomsGrid.SortedColumn, ListSortDirection.Descending); } } for (int i = 0; i < RoomsGrid.ColumnCount; i++) { RoomsGrid.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic; } LoadingGrid = false; SaveAndContinue.Enabled = false; SaveAndExit.Enabled = false; toolStripButton9.Text = "Exit"; }
private void Save_Click(object sender, EventArgs e) { int i = 1; RoomsGrid.EndEdit(); try { i = RoomsGrid.CurrentCell.RowIndex; } catch (Exception ex) { } try { RoomsGrid.EndEdit(); if (RoomsGrid.RowCount == 1) { RoomsGrid.CurrentCell = RoomsGrid[1, 0]; bindingNavigatorAddNewItem1.PerformClick(); RoomsGrid.CurrentCell = RoomsGrid[1, 1]; bindingSource1.RemoveCurrent(); RoomsGrid.CurrentCell = RoomsGrid[1, 0]; } else { if (i > 1) { RoomsGrid.CurrentCell = RoomsGrid[1, i - 1]; } else { RoomsGrid.CurrentCell = RoomsGrid[1, 0]; RoomsGrid.CurrentCell = RoomsGrid[1, 1]; RoomsGrid.CurrentCell = RoomsGrid[1, 0]; } RoomsGrid.CurrentCell = RoomsGrid[1, i]; } } catch (Exception ex) { } try { LoadingGrid = true; RoomsGrid.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(); } }