private void UpdateContentBox() { List <List <string> > list = mySqlManager.SqlCommand(MySqlCommands.ListAllTableContent(nodeSelected.Parent.Text + "." + nodeSelected.Text)); if (list == null) { ShowMessage(mySqlManager.ResponseMessage); } else { listBox1.Items.Clear(); foreach (List <string> item in list) { if (item.Count == 5) { listBox1.Items.Add(new DataType(item[1], item[2], item[3])); } else { string str = ""; foreach (string field in item) { str += string.Format("[{0}] ", field); } listBox1.Items.Add(str); } } } }
private void UpdateListView() { treeView1.Nodes.Clear(); List <List <string> > dblist = mySqlManager.SqlCommand(MySqlCommands.ListAllDatabases()); if (dblist != null) { treeView1.BeginUpdate(); for (int i = 0; i < dblist.Count; i++) { treeView1.Nodes.Add(dblist[i][0]); List <List <string> > tablelist = mySqlManager.SqlCommand(MySqlCommands.ListAllTables(dblist[i][0])); if (tablelist != null) { foreach (List <string> table in tablelist) { treeView1.Nodes[i].Nodes.Add(table[0]); } } else { ShowMessage(mySqlManager.ResponseMessage); } } treeView1.EndUpdate(); } else { ShowMessage(mySqlManager.ResponseMessage); } }
private void removeTableButton_Click(object sender, EventArgs e) { List <List <string> > tablelist = mySqlManager.SqlCommand(MySqlCommands.RemoveTable(nodeSelected.Text)); if (tablelist == null) { ShowMessage(mySqlManager.ResponseMessage); } UpdateListView(); }
private void addTableButton_Click(object sender, EventArgs e) { InputPopup popup = new InputPopup("Enter Table Name", (string input) => { List <List <string> > list = mySqlManager.SqlCommand(MySqlCommands.CreateNewTable(nodeSelected.Text, input)); if (list == null) { ShowMessage(mySqlManager.ResponseMessage); } UpdateListView(); }); popup.Show(); }
private void createDBButton_Click(object sender, EventArgs e) { InputPopup popup = new InputPopup("Enter Database Name", (string input) => { List <List <string> > list = mySqlManager.SqlCommand(MySqlCommands.CreateNewDatabase(input)); if (list == null) { ShowMessage(mySqlManager.ResponseMessage); } UpdateListView(); }); popup.Show(); }
private void insertButton_Click(object sender, EventArgs e) { InsertDataPopup popup = new InsertDataPopup("Enter Table Name", (string fname, string lname, string email) => { DataType data = new DataType(fname, lname, email); List <List <string> > list = mySqlManager.SqlCommand(MySqlCommands.InsertTableContent(nodeSelected.Parent.Text + "." + nodeSelected.Text, data)); if (list == null) { ShowMessage(mySqlManager.ResponseMessage); } UpdateContentBox(); }); popup.Show(); }