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);
}
