Esempio n. 1
0
        private void LoadIndexes(string table)
        {
            DataTable dt = _sqliteManager.GetIndexes(table);

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[table].Nodes["Indexes"].Nodes.Add(dt.Rows[i].ItemArray[0].ToString(),
                                                                                                  dt.Rows[i].ItemArray[0].ToString(), "tag.png", "tag.png");
                DatabaseTree.SelectedNode.Nodes["Tables"].Nodes[table].Nodes["Indexes"].Nodes[i].ContextMenuStrip = IndexMenuStrip;
            }
        }
        private bool IndexExists(string indexName, string tablename)
        {
            DataTable dataTable = _sqliteManager.GetIndexes(tablename);

            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                if (dataTable.Rows[i].ItemArray[0].ToString() == indexName)
                {
                    return(true);
                }
            }
            return(false);
        }