private void LoadTables() { DataTable dt = _sqliteManager.GetTables(); for (int i = 0; i < dt.Rows.Count; i++) { DatabaseTree.SelectedNode.Nodes["Tables"].Nodes.Add( dt.Rows[i].ItemArray[0].ToString(), dt.Rows[i].ItemArray[0].ToString(), "table.png", "table.png"); DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].ContextMenuStrip = TableMenuStrip; DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Nodes.Add("Columns", "Columns", "columns.png", "columns.png"); DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Nodes.Add("Indexes", "Indexes", "tags.png", "tags.png"); DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Nodes["Indexes"].ContextMenuStrip = IndexesMenuStrip; DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Nodes.Add("Triggers", "Triggers", "tools.png", "tools.png"); DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Nodes["Triggers"].ContextMenuStrip = TriggersMenuStrip; string tableName = DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[i].Text; LoadColumns(tableName); LoadIndexes(dt.Rows[i].ItemArray[0].ToString()); LoadTriggers(tableName); } this.Refresh(); }
private bool TableExists(string tableName) { DataTable dt = _sqliteManager.GetTables(); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].ItemArray[0].ToString() == tableName) { return(true); } } return(false); }