public SQLResult Select(string sql, params object[] args) { SQLResult retData = new SQLResult(); StringBuilder sqlString = new StringBuilder(); // Fix for floating point problems on some languages sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql, args); MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection); try { SqlData = sqlCommand.ExecuteReader(CommandBehavior.Default); retData.Load(SqlData); retData.Count = retData.Rows.Count; SqlData.Close(); } catch (MySqlException ex) { Log.Message(LogType.ERROR, "{0}", ex.Message); } return(retData); }
public SQLResult Select(string sql, params object[] args) { StringBuilder sqlString = new StringBuilder(); // Fix for floating point problems on some languages sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql); using (var Connection = new MySqlConnection(ConnectionString)) { Connection.Open(); MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection); try { List <MySqlParameter> mParams = new List <MySqlParameter>(args.Length); foreach (var a in args) { mParams.Add(new MySqlParameter("", a)); } sqlCommand.Parameters.AddRange(mParams.ToArray()); using (var SqlData = sqlCommand.ExecuteReader(CommandBehavior.Default)) { using (var retData = new SQLResult()) { retData.Load(SqlData); retData.Count = retData.Rows.Count; return(retData); } } } catch (MySqlException ex) { Log.Message(LogType.ERROR, "{0}", ex.Message); } } return(null); }
public SQLResult Select(string sql, params object[] args) { var sqlString = new StringBuilder(); // Fix for floating point problems on some languages sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql); try { using (var sqlCommand = new MySqlCommand(sqlString.ToString(), connection)) { var mParams = new List <MySqlParameter>(args.Length); foreach (var a in args) { mParams.Add(new MySqlParameter("", a)); } sqlCommand.Parameters.AddRange(mParams.ToArray()); using (var SqlData = sqlCommand.ExecuteReader(CommandBehavior.Default)) { if (SqlData.HasRows) { using (var retData = new SQLResult()) { retData.Load(SqlData); retData.Count = retData.Rows.Count; return(retData); } } } } } catch (Exception ex) { ExceptionLog.Write(ex); } return(null); }