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