public virtual List <MySqlError> ReportWarnings(MySqlConnection connection) { List <MySqlError> list = new List <MySqlError>(); using (MySqlDataReader mySqlDataReader = new MySqlCommand("SHOW WARNINGS", connection) { InternallyCreated = true }.ExecuteReader()) { while (mySqlDataReader.Read()) { list.Add(new MySqlError(mySqlDataReader.GetString(0), mySqlDataReader.GetInt32(1), mySqlDataReader.GetString(2))); } } MySqlInfoMessageEventArgs mySqlInfoMessageEventArgs = new MySqlInfoMessageEventArgs(); mySqlInfoMessageEventArgs.errors = list.ToArray(); if (connection != null) { connection.OnInfoMessage(mySqlInfoMessageEventArgs); } return(list); }
private void buttonDbTest_Click(object sender, EventArgs e) { reopenDatabase(); comboBoxSchema.Items.Clear(); MySqlDataReader dr = new MySqlCommand("SHOW DATABASES;", _conn).ExecuteReader(); while(dr.Read()) { comboBoxSchema.Items.Add(dr.GetString(0)); } dr.Close(); }
private static List<string> GetTableNames() { try { m_Connection.Open(); MySqlDataReader mysqlDR = new MySqlCommand(ConfigConst.MysqlCmd, m_Connection).ExecuteReader(); List<string> tables = new List<string>(); while (mysqlDR.Read()) { string table = mysqlDR.GetString(0); if (!tables.Contains(table) && table.Contains(ConfigConst.TableNameKeyWord)) { tables.Add(table); } } m_Connection.Close(); return tables; } catch (Exception e) { Debug.Log("Error : " + e.Message); throw; } }
public static Request getItem() { Request r = new Request(); try { MySqlDataReader rdr = new MySqlCommand("SELECT `id`,`steam_id`,`type`,`priority` FROM `queue` WHERE `id` IN (SELECT `queue_id` FROM `queue_status` WHERE `active`=1 AND `status`=" + (int)RequestStatus.Waiting + ") ORDER BY `priority` DESC, `id` ASC LIMIT 1", QueueConnection).ExecuteReader(); while (rdr.Read()) { r.ID = rdr.GetInt32(0); r.User = rdr.GetUInt64(1); r.TradeType = (Bot.TradeTypes)rdr.GetInt32(2); r.Priority = rdr.GetInt32(3); } rdr.Close(); r.Data = new string[Int32.Parse((new MySqlCommand("SELECT COUNT(`data`) FROM `queue_items` WHERE `queue_id`=" + r.ID, conn)).ExecuteScalar().ToString())]; rdr = (new MySqlCommand("SELECT `data` FROM `queue_items` WHERE `queue_id`=" + r.ID, conn)).ExecuteReader(); int i = 0; while (rdr.Read()) r.Data[i++] = rdr.GetString(0); rdr.Close(); } catch (Exception e) { log.Error("Error getting new request: " + e.Message); } return r; }
private List<string> GetTableNames() { try { this.m_Connection.Open(); MySqlDataReader mysqlDR = new MySqlCommand(MyConst.MysqlCmd, this.m_Connection).ExecuteReader(); List<string> tables = new List<string>(); while (mysqlDR.Read()) { string table = mysqlDR.GetString(0); if (!tables.Contains(table) && table.Contains(MyConst.TableNameKeyWord)) { tables.Add(table); } } this.m_Connection.Close(); return tables; } catch (Exception e) { Console.WriteLine("Error : " + e.Message); throw; } }