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);
}
