Exemplo n.º 1
0
        public MySqlDataReader Select(string query)
        {
            SampleConnection sample = new SampleConnection();
            MySqlConnection  conn   = sample.GetConnection();

            log.Info("Select...");
            MySqlCommand cmd = new MySqlCommand();

            cmd.Connection  = conn;
            cmd.CommandText = query;
            MySqlDataReader rd = cmd.ExecuteReader();

            //sample.Close(conn);
            return(rd);
        }
Exemplo n.º 2
0
        public void Insert(string query)
        {
            //throw new NotImplementedException();
            SampleConnection sample = new SampleConnection();
            MySqlConnection  conn   = sample.GetConnection();

            log.Info("Create...");
            MySqlCommand cmd = new MySqlCommand();

            cmd.Connection  = conn;
            cmd.CommandText = query;
            cmd.ExecuteNonQuery();
            sample.Close(conn);
            return;
        }