public CreateIndexForm(SQLite database,string tableName)
{
InitializeComponent();
this.TablesComboBox.Text = tableName;
db = database;
AddColumnsToGrid();
}
public AddDataForm(string tableName,SQLite database)
{
db = database;
name = tableName;
InitializeComponent();
InitializeDataGrid();
}
public ConnectDatabaseForm(string dbname, SQLite database)
{
db = database;
InitializeComponent();
name = dbname;
this.DBNameLabel.Text = dbname;
}
private void ConnectDatabase_Click(object sender, EventArgs e)
{
if (DatabaseTree.SelectedNode.Text != "Databases")
{
try
{
//trying new code heree
//string dbName = DatabaseTree.SelectedNode.Text;
//string oldDBname="";
//for (int i = 0; i < DatabaseTree.Nodes[0].Nodes.Count; i++)
//{
// if (DatabaseTree.Nodes[0].Nodes[i].Nodes.Count > 1)
// {
// oldDBname = DatabaseTree.Nodes[0].Nodes[i].Text;
// }
//}
//DatabaseTree.Nodes[0].Nodes[oldDBname].Nodes.Clear();
//DatabaseTree.CollapseAll();
//DatabaseTree.Nodes[0].Nodes[dbName].ExpandAll();
//DatabaseTree.SelectedNode = DatabaseTree.Nodes[0].Nodes[dbName];
//trying new code heree
db.ConnectDatabase(DatabaseTree.SelectedNode.Text.ToString());
dbs = db;
if (DatabaseTree.SelectedNode.Nodes.Count == 0)
{
DatabaseTree.SelectedNode.Nodes.Add("Tables", "Tables", "tablas.png", "tablas.png");
DatabaseTree.SelectedNode.Nodes["Tables"].ContextMenuStrip = TablesMenuStrip;
LoadTables();
DatabaseTree.SelectedNode.Nodes.Add("Views", "Views", "vistas.png", "vistas.png");
DatabaseTree.SelectedNode.Nodes["Views"].ContextMenuStrip = ViewsMenuStrip;
LoadViews();
DatabaseTree.SelectedNode.Expand();
}
}
catch (Exception ex)
{
AppendText(ex.Message, Color.Red);
}
}
}
public CreateTableForm(SQLite database)
{
db = database;
InitializeComponent();
}
public CreateTriggerForm(SQLite database,string table_name)
{
db = database;
InitializeComponent();
this.OnTableComboBox.Text = table_name;
}
