private DataTable SafeSelect(string sql)
{
try
{
return(_db.ExecuteDataTableSQL(sql, null));
}
catch (System.Data.SqlClient.SqlException ex)
{
if (_errors.ContainsKey(ex.Number))
{
_errors[ex.Number].count++;
}
else
{
sqlerror error = new sqlerror();
error.count = 1;
error.sql = sql;
error.Message = ex.Message;
_errors.Add(ex.Number, error);
}
}
return(null);
}
private void GetAllDBs()
{
List<string> searchlist;
string connstr;
string sql;
string provider = cbProvider.SelectedValue.ToString();
// Get database names
if (provider == "System.Data.SqlClient")
{
if (cbSQLLogin.Checked)
{
connstr = "Server=" + cbServer.Text + "; Database=master; Trusted_Connection=False; User ID=" + tbUsername.Text + "; Password="******";";
}
else
{
connstr = "Server=" + cbServer.Text + "; Database=master; Trusted_Connection=True;";
}
sql = "select name from sysdatabases order by name";
}
else if (provider == "MySql.Data.MySqlClient")
{
connstr = "Data Source=" + cbServer.Text + "; Database=information_schema; User ID=" + tbUsername.Text + "; Password="******";";
sql = "select schema_name name from schemata order by schema_name";
}
else // Unknown provider
{
throw new NotImplementedException("Unsupported database provider: '" + provider + "'.");
}
System.Data.DataTable dtDBs;
string dbs = string.Empty;
using (db mydb = new db(provider, connstr))
{
dtDBs = mydb.ExecuteDataTableSQL(sql, null);
}
if (cbDBPattern.Checked)
{
searchlist = new List<string>();
foreach (string row in tbDatabases.Text.Replace("\r", "").Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries))
{
searchlist.Add(row);
}
}
else
searchlist = null;
foreach (DataRow drDB in dtDBs.Rows)
{
if (searchlist == null)
{
dbs += drDB["name"].ToString() + Environment.NewLine;
}
else
{
string dbname = drDB["name"].ToString();
foreach (string search in searchlist)
{
if (System.Text.RegularExpressions.Regex.IsMatch(
dbname, search, System.Text.RegularExpressions.RegexOptions.IgnoreCase))
{
dbs += dbname + Environment.NewLine;
break;
}
}
}
}
tbDatabases.Text = dbs.TrimEnd();
return;
}
private void GetAllDBs()
{
List <string> searchlist;
string connstr;
string sql;
string provider = cbProvider.SelectedValue.ToString();
// Get database names
if (provider == "System.Data.SqlClient")
{
if (cbSQLLogin.Checked)
{
connstr = "Server=" + cbServer.Text + "; Database=master; Trusted_Connection=False; User ID=" + tbUsername.Text + "; Password="******";";
}
else
{
connstr = "Server=" + cbServer.Text + "; Database=master; Trusted_Connection=True;";
}
sql = "select name from sysdatabases order by name";
}
else if (provider == "MySql.Data.MySqlClient")
{
connstr = "Data Source=" + cbServer.Text + "; Database=information_schema; User ID=" + tbUsername.Text + "; Password="******";";
sql = "select schema_name name from schemata order by schema_name";
}
else // Unknown provider
{
throw new NotImplementedException("Unsupported database provider: '" + provider + "'.");
}
System.Data.DataTable dtDBs;
string dbs = string.Empty;
using (db mydb = new db(provider, connstr))
{
dtDBs = mydb.ExecuteDataTableSQL(sql, null);
}
if (cbDBPattern.Checked)
{
searchlist = new List <string>();
foreach (string row in tbDatabases.Text.Replace("\r", "").Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries))
{
searchlist.Add(row);
}
}
else
{
searchlist = null;
}
foreach (DataRow drDB in dtDBs.Rows)
{
if (searchlist == null)
{
dbs += drDB["name"].ToString() + Environment.NewLine;
}
else
{
string dbname = drDB["name"].ToString();
foreach (string search in searchlist)
{
if (System.Text.RegularExpressions.Regex.IsMatch(
dbname, search, System.Text.RegularExpressions.RegexOptions.IgnoreCase))
{
dbs += dbname + Environment.NewLine;
break;
}
}
}
}
tbDatabases.Text = dbs.TrimEnd();
return;
}