예제 #1
0
        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);
        }