private void LoadTriggers(string table) { DataTable dt = _sqliteManager.GetTriggers(table); for (int i = 0; i < dt.Rows.Count; i++) { DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[table].Nodes["Triggers"].Nodes.Add(dt.Rows[i].ItemArray[0].ToString(), dt.Rows[i].ItemArray[0].ToString(), "tool.png", "tool.png"); DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[table].Nodes["Triggers"].Nodes[i].ContextMenuStrip = TriggerMenuStrip; } }
private bool TriggerExists(string tableName, string triggerName) { DataTable dataTable = _sqliteManager.GetTriggers(tableName); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i].ItemArray[0].ToString() == triggerName) { return(true); } } return(false); }