private IQueryBuilder BuildSQL() { teSQL.Clear(); try { SqlQueryBuilder builder = new SqlQueryBuilder(_query); builder.Formats.SetDefaultFormats(FormatType.MsSqlServer); if (builder.CanBuild) { builder.BuildSQL(); string sql = builder.Result.SQL; teSQL.Text = sql; return(builder); } return(null); } catch (Exception ex) { //Simply ignore any possible exception MessageBox.Show(ex.Message); } return(null); }
protected void UpdateSql() { try { SqlQueryBuilder builder = new SqlQueryBuilder(query); builder.BuildSQL(); SqlTextBox.Text = builder.Result.SQL; QueryTextFormats formats = new QueryTextFormats(); formats.UseHtml = true; formats.UseMathSymbolsForOperators = true; literalQueryText.Text = query.GetConditionsText(formats); ResultGrid.Visible = false; } catch { SqlTextBox.Text = ""; literalQueryText.Text = ""; } }
void SetSql() { SqlQueryBuilder builder = new SqlQueryBuilder((DbQuery)queryPanel.Query); builder.Formats.SetDefaultFormats(FormatType.MsSqlServer); builder.Formats.OrderByStyle = OrderByStyles.Aliases; builder.Formats.DateFormat = "MM/dd/yyyy"; builder.Formats.DateTimeFormat = "MM/dd/yyyy HH:mm"; if (!builder.CanBuild) { return; } builder.BuildSQL(); string sql = builder.Result.SQL; textBoxSql.Text = sql; buttonExecute.IsEnabled = !string.IsNullOrEmpty(sql); }
protected void UpdateSql() { try { SqlQueryBuilder builder = new SqlQueryBuilder(query); builder.BuildSQL(); SqlTextBox.Text = builder.Result.SQL; QueryTextFormats formats = new QueryTextFormats(); formats.UseHtml = true; formats.UseMathSymbolsForOperators = true; ResultGrid.Visible = false; } catch { SqlTextBox.Text = ""; } }