//public string BuildSQLQuery() //{ //} #endregion #region Execute Query /// <summary> /// Executes SQL queries /// </summary> /// <param name="queryString">Accepts finished query string</param> /// <returns> /// Returns a Datatable with the results or null if it's an insert /// </returns> public DataTable ExecuteMySQLQuery(string queryString) { _dbCon = DBConnectionModel.Instance(); try { if (_dbCon.IsConnected("localhost", "autoDB", "root", "", "3306")) { var cmd = new MySqlCommand(queryString, _dbCon.Connection); MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter(cmd); DataTable dtRecord = new DataTable(); sqlDataAdapter.Fill(dtRecord); return(dtRecord); } else { return(null); } } catch (MySqlException sqlex) { Protocol.WriteToProtocol(0, "IsConnected() :" + sqlex.Message + sqlex.StackTrace, "DB Connection Error"); MessageBox.Show(sqlex.Message); return(null); } finally { _dbCon.CloseSqlConnection(); } }
public static DBConnectionModel Instance() { if (_instance == null) { _instance = new DBConnectionModel(); } return(_instance); }