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 = "";
}
}
