private void simpleButtonRunScript_Click_1(object sender, EventArgs e)
{
tabControl2.TabPages.Clear();
string[] scripts = recSorgular.Text.Trim().Split(';'); //; den sonraki sorguları ayırdık. her sorgu farklı tabpagede görüntülensin diye.
if (recSorgular.Text != "")
{
for (int i = 0; i < scripts.Length; i++)
{
if (scripts[i].Trim() != "")
{
DbOperation baglanti = new DbOperation();
DataTable dt = baglanti.Listele(scripts[i].Trim(), IP, Port, UserName, Password, cbDatabase.Text);
if (dt != null && dt.Rows.Count > 0)
{
TabOlustur();
GridControl grid = getgrid(i);
grid.DataSource = dt;
}
else
{
MessageBox.Show("Tablo Boş");
}
}
}
}
else
{
MessageBox.Show("Lütfen Bir Script Giriniz");
}
}
public void ComboDoldur()
{
DbOperation baglanti = new DbOperation();
DataTable dt = baglanti.Listele("SHOW DATABASES", IP, Port, UserName, Password, cbDatabase.Text);
if (dt.Rows.Count > 0)
{
foreach (DataRow satir in dt.Rows)
{
cbDatabase.Items.Add(satir[0]);
}
}
}
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 = "";
}
}
