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