static public string SqlString(string sSql) { string sResult = ""; using (QMySql s = new QMySql()) { s.Open(sSql); if (s.GetRow()) { sResult = s.GetString(0); } } return(sResult); }
static public IEnumerable <string> SqlList(string sql) { List <string> result = new List <string>(); using (QMySql s = new QMySql()) { s.Open(sql); while (s.GetRow()) { result.Add(s.GetString(0)); } } return(result); }
static public int Exec(string sSql, string connectString = null) { if (connectString == null) { connectString = ConnectString; } int nResult = 0; using (QMySql s = new QMySql(connectString)) { nResult = s.Execute(sSql); } return(nResult); }
static public int SqlInt(bool useRawValues, string sql, params object[] args) { int nResult = 0; AddArgsToQuery(useRawValues, ref sql, args); using (QMySql s = new QMySql()) { s.Open(sql); if (s.GetRow()) { nResult = s.GetInt(0); } } return(nResult); }
public static void Connect(string host, string database, string user, string password) { QMySql.ConnectString = "Server=" + host + ";Encrypt=false;Database=" + database + ";Uid=" + user + ";Pwd=" + password + ";Allow User Variables=True;"; QMySql.SqlInt("select count(*) FROM INFORMATION_SCHEMA.TABLES"); }