private void Button1_Click(object sender, EventArgs e) { var baseSql = $"create proc {nameTextBox.Text} ("; foreach (DataGridViewRow row in procedureParametersDataGrid.Rows) { if (!row.IsNewRow) { baseSql += $"@{row.Cells["ParameterName"].Value} {row.Cells["DataType"].Value},"; } } var newSql = baseSql.Remove(baseSql.Length - 1); newSql += $") as {procedureDefinitionTextBox.Text}"; var ddlViewer = new DdlViewer(baseSql); ddlViewer.ShowDialog(); if (ddlViewer.DialogResult != DialogResult.OK) { return; } CurrentInformation.ConnectionProperties.Connection.Execute(baseSql); TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView); }
private void NewConnectionToolStripMenuItem_Click(object sender, EventArgs e) { var connectionForm = new ConnectionForm(); connectionForm.ShowDialog(); if (connectionForm.DialogResult != DialogResult.OK) { return; } TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, connectionsTreeView); connectionsTreeView.Nodes[0].Expand(); }
private void Button1_Click(object sender, EventArgs e) { string baseSql = $"create view {nameTextBox.Text} as {sqlTextBox.Text}"; var ddlViewer = new DdlViewer(baseSql); ddlViewer.ShowDialog(); if (ddlViewer.DialogResult != DialogResult.OK) { return; } CurrentInformation.ConnectionProperties.Connection.Execute(baseSql); TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView); }
private void Button1_Click(object sender, EventArgs e) { var baseSql = $"create table {nameTextBox.Text} ("; foreach (DataGridViewRow row in tableDefinitionDataGrid.Rows) { if (row.IsNewRow) { continue; } baseSql += $"{row.Cells["FieldName"].Value} {row.Cells["DataType"].Value}"; if (row.Cells["NotNull"].Value != null && (bool)row.Cells["NotNull"].Value) { baseSql += " NOT NULL"; } if (row.Cells["PrimaryKey"].Value != null && (bool)row.Cells["PrimaryKey"].Value) { baseSql += " PRIMARY KEY"; } baseSql += ","; } baseSql += ");"; var ddlViewer = new DdlViewer(baseSql); ddlViewer.ShowDialog(); if (ddlViewer.DialogResult != DialogResult.OK) { return; } CurrentInformation.ConnectionProperties.Connection.Execute(baseSql); TreeViewConnectionBootstrapper.Init(CurrentInformation.ConnectionProperties, TreeView); tableDefinitionDataGrid.DataSource = null; }