private void uxGoButton_Click(object sender, EventArgs e) { /* * if (inProgress.uxInProgressMessage()) * { * uxGoButton_Click(sender, e); * } //*/ string database; if (!db) { database = null; } else { database = uxValueGrid.Rows[0].Cells[1].Value.ToString(); } List <string> parameters = new List <string>(); if (parameterCount > 0) { for (int i = 0; i < parameterCount; i++) { if (parameterCount > i && db) { parameters.Add(uxValueGrid.Rows[i + 1].Cells[1].Value.ToString()); } else if (parameterCount > i) { parameters.Add(uxValueGrid.Rows[i].Cells[1].Value.ToString()); } } } var server = servers[0]; for (int i = 0; i < servers.Count; i++) { if (servers[i].ServerName == uxServersListBox.SelectedItem.ToString()) { server = servers[i]; } } runSQLQuery run = new runSQLQuery(); uxOutputDataGrid.Visible = true; uxOutputDataGrid.DataSource = run.runQuery(queryText, server, database, parameters); }
private void uxGoButton_Click(object sender, EventArgs e) { if (this.uxOutputDataGrid.DataSource != null) { this.uxOutputDataGrid.DataSource = null; } else { this.uxOutputDataGrid.Rows.Clear(); } //check if server and query is selected if (uxServersListBox.SelectedItem == null && uxQueryListBox.SelectedItem == null) { uxNullServerError.SetError(lblSQLServers, "You need to select a server!"); uxNullQueryError.SetError(lblQueries, "You need to select a Query!"); return; } else if (uxServersListBox.SelectedItem == null) { uxNullQueryError.Dispose(); //removes Query error if displayed uxNullServerError.SetError(lblSQLServers, "You need to select a server!"); return; } else if (uxQueryListBox.SelectedItem == null) { uxNullServerError.Dispose(); //removes Server error if displayed uxNullQueryError.SetError(lblQueries, "You need to select a Query!"); return; } else { uxNullQueryError.Dispose(); //removes Query error if displayed uxNullServerError.Dispose(); //removes Server error if displayed } //checks for the values for (int i = 0; i < (uxValueGrid.Rows.Count - 1); i++) { if (uxValueGrid.Rows[i].Cells[1].Value.ToString() == "" || uxValueGrid.Rows[i].Cells[1].Value == null) { uxNullValue.SetError(lblValue, "Insert some values!"); return; } else { uxNullValue.Dispose(); //removes value error if displayed } } var query = queries[0]; for (int i = 0; i < queries.Count; i++) { if (queries[i].queryName == uxQueryListBox.SelectedItem.ToString()) { query = queries[i]; } } runSQLQuery run = new runSQLQuery(); string database = null; if (!servers[uxServersListBox.SelectedIndex].WindowsAuthentication) { database = uxValueGrid.Rows[0].Cells[1].Value.ToString(); } List <string> parameters = new List <string>(); if (query.paramList.Count > 0) { for (int i = 0; i < query.paramList.Count; i++) { if (query.paramList.Count > i && query.database != null) { parameters.Add(uxValueGrid.Rows[i + 1].Cells[1].Value.ToString()); } else if (query.paramList.Count > i) { parameters.Add(uxValueGrid.Rows[i].Cells[1].Value.ToString()); } } } uxOutputDataGrid.Visible = true; uxOutputDataGrid.DataSource = run.runQuery(query.queryText, servers[uxServersListBox.SelectedIndex], database, parameters); }