private void cmsvw_alterview_Click(object sender, EventArgs e)
{
//birşey seçilmemişse ve view değilse dön
if (Tv_DbStructure.SelectedNode == null)
{
return;
}
if (Tv_DbStructure.SelectedNode.Parent.Name != "vw")
{
return;
}
//view oluşturma komutunu al
SQLiteConnection cnn = new SQLiteConnection(Global.SqlStr);
cnn.Open();
SQLiteCommand emir = new SQLiteCommand("select sql from sqlite_master where name='" + Tv_DbStructure.SelectedNode.Name + "'", cnn);
string _createscript = "";
try { _createscript = emir.ExecuteScalar().ToString(); }
catch { }
cnn.Close();
//viewekle iceriği alındı
QueryScreen frms = new QueryScreen();
frms.fastColoredTextBox1.Text = "DROP VIEW IF EXISTS " + Tv_DbStructure.SelectedNode.Name + ";" + Environment.NewLine +
_createscript;
frms.MdiParent = this;
frms.Show();
}
private void newQueryWindowToolStripMenuItem_Click(object sender, EventArgs e)
{
QueryScreen frms = new QueryScreen();
frms.MdiParent = this;
frms.Show();
}
private void csm_select_Click(object sender, EventArgs e)
{
if (Tv_DbStructure.SelectedNode == null)
{
return;
}
QueryScreen frms = new QueryScreen();
frms.TableName = Tv_DbStructure.SelectedNode.Name;
frms.MdiParent = this;
frms.Show();
}
private void cmsvw_newview_Click(object sender, EventArgs e)
{
//birşey seçilmemişse ve view değilse dön
if (Tv_DbStructure.SelectedNode == null)
{
return;
}
if (Tv_DbStructure.SelectedNode.Parent.Name != "vw")
{
return;
}
QueryScreen frms = new QueryScreen();
frms.fastColoredTextBox1.Text = "CREATE VIEW myview1 AS " + Environment.NewLine;
frms.MdiParent = this;
frms.Show();
}