private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { DbOperation db = new DbOperation(); DataTable dt = db.Listele("show columns from " + lbTables.Text, IP, Port, UserName, Password, cbDatabase.Text); if (dt.Rows.Count > 0) { lbFields.Items.Clear(); lbFields.Items.Add("*"); foreach (DataRow satir in dt.Rows) { lbFields.Items.Add(satir[0]); } } }
private void ComboBox1_SelectedIndexChanged_1(object sender, EventArgs e) { DbOperation baglanti = new DbOperation(); DataTable dt = baglanti.Listele("SHOW TABLES", IP, Port, UserName, Password, cbDatabase.Text); if (dt.Rows.Count > 0) { lbTables.Items.Clear(); lbFields.Items.Clear(); foreach (DataRow satir in dt.Rows) { lbTables.Items.Add(satir[0]); } } else { lbTables.Text = ""; } }