//Get all Databases | Using DB name
internal static List <string> GetAllDatabases()
{
//Temp list
List <string> temp = new List <string>();
//create connection and open it
MySqlConnection connection = DbInfo.Connection();
//Create command
MySqlCommand id_cmd = connection.CreateCommand();
id_cmd.CommandText =
"SELECT `ID`, `Datasource`, `Username`, `Password`, `Databasename` FROM `databases`";
//Create reader
MySqlDataReader reader = id_cmd.ExecuteReader();
//While reading
while (reader.Read())
{
temp.Add(reader["Databasename"].ToString());
}
return(temp);
}
//Create Database Connection | Using DB name
internal static MySqlConnection CreateDBConnection(string DBName)
{
string constring = "";
//create connection and open it
MySqlConnection connection = DbInfo.Connection();
MySqlCommand id_cmd = connection.CreateCommand();
id_cmd.CommandText =
"SELECT `ID`, `Datasource`, `Username`, `Password`, `Databasename` FROM `databases` WHERE Databasename = @Databasename";
id_cmd.Parameters.AddWithValue("@Databasename", DBName);
MySqlDataReader reader = id_cmd.ExecuteReader();
//if match is found
if (reader.Read())
{
constring = "datasource = " + reader["Datasource"] + "; username = "******"Username"] + "; password="******"Password"] + "; database = " + reader["Databasename"].ToString();
//Create mysqlconnection
MySqlConnection newcon = new MySqlConnection(constring);
newcon.Open();
return(newcon);
}
else
{
//Return connection
MySqlConnection nl = null;
return(nl);
}
}
